Remove duplicates with this Google Sheets Add-on.

Source: Remove Duplicates – Google Sheets add-on

Remove Duplicates is a Googel Sheets add-on that will help you manage duplicate information in a spreadsheet. There is an extensive help page available on how to use the add-on.