Excel: Create a list (without spaces or blanks) from column of values
<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>