B
Brad
I am looking for a formula, as opposed to a VBA solution, where I have a
column of text entries, but with empty cells interspersed here and there
from top to bottom sort of like this for, say, cells A1:A6:
House
(empty cell)
Car
(empty cell)
(empty cell)
Dog
....like that with empty cells between each of the cells holding text.
Is there a way, via a formula to distill the above column so that it looks
like this:
House
Car
Dog
in another column or series of cells on the spreadsheet?
My thanks in advance if anyone can point me in the direction of a solution!
Brad
column of text entries, but with empty cells interspersed here and there
from top to bottom sort of like this for, say, cells A1:A6:
House
(empty cell)
Car
(empty cell)
(empty cell)
Dog
....like that with empty cells between each of the cells holding text.
Is there a way, via a formula to distill the above column so that it looks
like this:
House
Car
Dog
in another column or series of cells on the spreadsheet?
My thanks in advance if anyone can point me in the direction of a solution!
Brad