How to Automatically Remove Duplicate Data in Google Sheets | Google Sheets Tutorials
When you are working with a lot of data in Google Sheets and find a lot of duplicate data. Then you want to delete it automatically, then you can do the following steps:
1. Select or highlight the data you want to delete.
2. Select the "Data" menu, then select the "Data Cleanup" menu.
3. On the "Data Cleanup" menu, select the "Remove Duplicate" menu.
3. Done.
Hope it is useful.