If you already have the unique names in column A but with some spaces, then
just copy and PastespecialValues that range to the bottom of column B and
then sort column B to get rid of the spaces.......

Vaya con Dios,
Chuck, CABGx3



"ferde" wrote:


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