Summarising a range in a column into a separate column

A

Aidan

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.
 
Top