hello. i am trying to sort through a list of data by displaying only one
occurance of a name from one column that has many repeating names into a new
column.

ex:

A B C
1 apple
apple
apple
pear
pear
apple
pear
orange
orange
orange
banana
banana

is it possible to show in column "B" only one "apple", one "pear", one
"orange", one "banana", etc? thanks in advance for your help.