highlight your column

Data==Filter=AdvancedFilter==Copy to another location... select your cell
and then click "Unique values only"

"Aidan" wrote:

If I have a column with say car, boat, train, other I want to generate a
separate column that only shows one incidence of each of the words (the words
appearing one below the other). I'd appreciate any help on this.

Thanks,

Aidan.