I have one column with a formula in multiple rows within the same column.
The formula pulls data from other parts of the spreadsheet or leaves the
cells blank. An example of the formula is =if(A1=0,€�€�,A1).

The outcome is to have a column with data in multiple rows mixed with blank
cells like so.

Bob
Mary
€œBlank€�
Joe
€œBlank€�
Jill

What I would like to do is pull the data automatically from this column
putting the data in another column excluding the €œBlank€� cells like so:

Bob
Mary
Joe
Jill

Any help would be most appreciated.

Thank you,

Wesley