Remove Duplicate Rows in a Google Spreadsheet With This Script
Long spreadsheets with a lot of entries can sometimes mistakenly have multiple instances of the same data. It\’s easy to remove them in Google Spreadsheet by making a simple script, says MakeUseOf.P
In Google Drive, go to Spreadsheet and click Tools -> Script Editor. Then go to File -> New -> Script File and name it \”removeDuplicates\” (without the quotes).