Summarising a range in a column into a separate column
 

This assumes original list is in B2:B12, adjust accordingly
In two columns immediately next to your list, enter (adjusting for location)
In C2, enter: =IF(COUNTIF($B$2:B2,B2)=1,B2,"") Copy formula down. This
blanks out duplicates
In D2 enter:
{=IF(ROW()-ROW($D$2:$D$12)+1ROWS($C$2:$C$12)-COUNTBLANK($C$2:$C$12),"",INDIRECT(ADDRESS(SMALL(( IF($C$2:$C$12<"",ROW($C$2:$C$12),ROW()+ROWS($C$2: $C$12))),ROW()-ROW($D$2:$D$12)+1),COLUMN($C$2:$C$12),4)))}
Copy formula down. This moves unique entries to top.
Note: 2nd formula is an array formula
Finally, hide column D.


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