A B
dog Cat


I have two columns. Column A has aprox 100 names that I would like to add to
column B. Is there a way to add all of the names in column A to the bottom of
Column B ?

I have already used an IF formula in column A to obtain the unique names
that I need so some of the cells in column A are blank now it is just a
matter of adding the cells with names to column B. .....but if you know of a
way to do this in one step I would be greatly obliged.

Thank you
Deb