title: Select all non-blank cells and associated Rows
body: <p>I've been searching for well over 3 hours for a formula or vba solution for this and for some reason can not find anything.</p>
  
  <p>I need something to look at a column, find all the non-blank cells, and output them elsewhere.
  Here is a small example table of the data:</p>
  
  <p><a href="https://i.stack.imgur.com/v14Zx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/v14Zx.png" alt="Original data"></a></p>
  
  <p>And here is what I would like to have outputed:</p>
  
  <p><a href="https://i.stack.imgur.com/AvgEW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AvgEW.png" alt="Output table"></a></p>
  
  <p>I've found many solutions most of which have been combinations of =value and =match but I either get zero results, or the results have blanks in the column that should never have blanks.</p>