I am trying to consolidate a column of say 10 rows down to the cells that do not contain a 0. I have a column that spits out either a name or a zero (depending on its date) and I want to consolidate this column to eliminate all zeros:

So Column A has the following in it:

Alpha
0
0
Charlie
0
Tango
Bravo
Delta
0
Foxtrot

I want column B to eliminate all 0's and Consolidate the column (while keeping the same order) to look like:

Alpha
Charlie
Tango
Bravo
Delta
Foxtrot


Any ideas would be greatly appreciated thanks