distilling a column of text entries

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
 
B

Bernard Liengme

Insert a row at the top and type a name for the column ("Data" is good)
Select this and all the data
Use Data | Filter | AutoFilter
Use the drop down handle in the top cell and select Non-blanks
Now do what you want to with them
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top