Multiple column entries to single ones

[Talbot]

If i have the following in a column:

Alpha
Alpha
Beta
Beta
Charlie
Alpha

Can i use a function to produce in another column every entry contained in the column above but only produce it once i.e.

Alpha
Beta
Charlie

Hope that makes sense.

Thanks
T

[arthurbr]

Have a look and following menu :
Data - Filter - Advanced filter
Check " Unique records only"