|Select your list and click on Data...Filter...Advanced Filter.|
In that dialog box, you can choose the options to:
1 - Copy to another location
2 - Unique records only
By choosing those 2 options, you will get a list of each unique item from your longer list.
Let us know if you need any further help.