title: Copying and pasting nonzero rows and adjacent cells
body: <p>I am dealing with a lot of GIS metadata that I am importing into Excel, with many rows and columns of blank or zero values. I am trying to take data like this:  </p>
  
  <p>(Left Column is the name, columns to the right are the values associated with that name)</p>
  
  <p><a href="https://i.stack.imgur.com/ibCPe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ibCPe.png" alt="enter image description here"></a></p>
  
  <p>and by only selecting the columns that have a value, end up with a new set of tables showing the nonzero rows and its corresponding name to the left:</p>
  
  <p><a href="https://i.stack.imgur.com/PnLnT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PnLnT.png" alt="enter image description here"></a></p>
  
  <p>I have tried doing it by filtering the data in a table so that it only shows nonzero values, copying that column and the far left column and pasting it onto a new sheet.  This is easy if I only have a few columns, but given the amount I have it is very painstaking.  I have to filter each column separately because the rows in each column may or may not have blanks or zeros depending on the column. </p>
  
  <p>Can the LOOKUP function be used for this, or would using VBA be better?  </p>