Get distinct values from a column and add them to a dropdown.

When any SharePoint list column is assigned to a Drop down it shows all item in it, unique and duplicates. this is really annoying in situations where we use the dropdown to filter a gallery. Ideally the drop down as the drop down supposed to show on...