try this. column a has your data, column b will have unique values column c will have the drop down list of the unique values applied..
Book1.xlsx