Hello! Friends

I have a list of names containing duplicate names and empty cells.

Using Data Validation List

I want get a drop down list of unique entries having no empty cells.

How can do this??? Please help me...