Oraganization with Excel?

Hey, I have a set of very unorganized data, and i wish to organize it in a new column by name in alphabetical order. (repeated data should only be listed once) Which function should do I use and how would you suggest i use it?

An example would be:
Cane
Doobinsky
Doobinsky
Alfred
Johnson
Xavier
Xavier
Arctavious


The desired result:
Arctavious
Alfred
Cane
Doobinsky
Johnson
Xavier

Thank you

Please read the forum rules, then start a new thread with a descriptive title.

Thanks.