Formula to show non-blank cells in column

[Anarchus]

Hi,

In my spreadsheet, Column F has data but many of the cells appear blank (based on a formula).

I need a formula that references Column F and returns all non-blank cells into Column H. Is this possible?

Example: 0 equals blank cells in Column F, in Column I, I need a formula to remove the blanks and replace with next cell with data in it.

Column F:

John
Adam
0
0
Patrick
0
Zoe
Sam

Column I:
John
Adam
Patrick
Zoe
Sam

[FlameRetired]

Try array entering this formula in I1 and filling down until you get blanks. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

Row\Col	F	G	H	I
1	John			John
2	Adam			Adam
3	0			Patrick
4	0			Zoe
5	Patrick			Sam
6	0
7	Zoe
8	Sam