To remove the duplicates you can use Advanced Filter. You Find it on the Data-Filter menu.

Select : "Copy to another location" and "Unique Records only".
"List Range", is the data you want to filter and "Copy To" is where you want to paste the result (probably another sheet). Leave "Criteria range" empty.