title: Excel: Create a list (without spaces or blanks) from column of values
body: <p>I have a checklist where if the user responds "yes" or "no", they will get a form or specific directions in column G. </p>
  
  <p>I would like to compile a list of all the forms needed (either in a separate column or below the checklist in column G) when they are done using the checklist. It would be nice if that list did not include blanks. So if items 1-3 and 5 are checked off, it would read like this (in column I4:I7, for instance):</p>
  
  <pre><code>Form 1
  Form 2
  Form 3 
  Form 5
  </code></pre>
  
  <p><a href="http://i.stack.imgur.com/i7wmE.jpg" rel="nofollow">Project</a></p>