Remove repeated rows.

Hey, all:
I have a table which consists of only one column. But it has thousands of rows. 80% of the rows are repeated. only 20% of them are unique. Looks like:

aaa
bbb
ccc
ccc
ccc
bbb
aaa
aaa
....
I want to eliminate the repeated ones, so that:
aaa
bbb
ccc

How can I do this?
thanks,
Hugo

Use advanced filter which will be easily solved your problem .......

User Filter then go in Data > Filter then again Click Advanced Filter > in List Range give your range and in the bottom click Unique Record Only .......