How to remove duplicate data from Google Sheet

High the column(s) you want to remove the duplicates

Click on Data>Data validation>Remove duplicates

Check on the header row if you are using header row

Select the columns that consist of the duplication

Click remove duplicates