My time is limited but I'll help you with the steps. You can find "how to" here on the Board.
1. copy all data to another sheet in the first column
(all next operations on the new sheet)
2. select all data
3. menu DATA / Filter / Advanced filter ==> unique
5. paste to the second column
6. delete the first column
(even manually it's done in relatively short time)