title: Create a list of non blank cell values from a range?
body: <p>I have a spreadsheet like so:</p>
  
  <pre><code>Column A
  
  Ducks
  Frogs
  &lt;Blank&gt;
  Rabbits
  &lt;blank&gt;
  Horse
  </code></pre>
  
  <p>I want to be able to create a list of all non blank cells in a range (column A) like so:</p>
  
  <pre><code>Ducks
  Frogs
  Rabbits
  Horse
  </code></pre>
  
  <p>I do not want blank values to be in my list.</p>
  
  <p>Also, where there is a blank value found in the range, my formula should skip and list the next non blank cell in the range.</p>
  
  <p>However at the moment i am getting 0</p>
  
  <p>Here's my array formula, please can someone show me where i am going wrong?</p>
  
  <pre><code>=IFERROR(INDEX($F$16:$F$5000,IF($G$16:$G$5000&lt;&gt;"",ROW($1:$5000)),1),"")
  </code></pre>