Maybe.........Data Filter Autofilter "non-blanks"

Vaya con Dios,
Chuck, CABGx3


"Michael" wrote in message
...
Hello

I have a column which is 40 rows deep.
In the column E2:E41 which has text and "".
In a another column H I would like to just display the text on
sequential rows.

Example
E8 = Hotel
E15= Taxi
E23 = Restaurant
E40= Car

I would like in display in column H
H2= Hotel
H3= Taxi
H4= Restaurant
H4= Car

Using formula only no VBA

Thanks

Michael