You can use Data | Filter | Advanced filter to get unique values only -
tick this option, and you may also want to tick "Copy to new location"
and specify a cell in another sheet, so that you still have your
original data.

Hope this helps.

Pete