I got around 50000 rows in column A
I need a list in column B with 1 instance of all duplicate cells from column
A.

i.e.:
A B
widgets widgets
widgets blue
widgets berry
widgets
blue
blue
snow
berry
berry
grass


Anyone know how to do this?