Excel Formula to skip blank
<p>I want to create dynamic formula to sort out values from column. Formula to fill in the cell when it contains text and skip the cell if that is blank and go to the next one.</p>

<p>Range is</p>

<pre><code>-A
-(BLANK CELL)
-(BLANK CELL)
-D
-E
-F
-(BLANK CELL)
-H
-(BLANK CELL)
</code></pre>

<p>Result from the formula</p>

<pre><code>-A
-E
-F
-H
</code></pre>