I am trying to make a drop down list from a table that was formed from an SQL database. The column I want to make the drop down list from has duplicate names in them.

I made a validation list with that column, but it has the duplicate names in it. Is there any way to get rid of the duplicates??

thanks