title: extract values which are not blank from a column in excel
body: <p>I have tried all similar posts to try and get this working, but nothing I try seems to work! </p>
  
  <p>I have a list with values in on a sheet called "All" which contains vales generated from a formula, these can show as text or as blank</p>
  
  <pre><code>        D
  5     text
  6   
  7     text
  8     text2
  9
  10    text
  </code></pre>
  
  <p>I would like this list generated on a different sheet ("Summary")  so it just shows the values eg:</p>
  
  <pre><code>     A
   1  text
   2  text
   3  text2
   4  text
  </code></pre>
  
  <p>Thanks in advance!</p>