› To remove duplicate rows in Google Sheets, select the complete table and use Data > Data cleanup > Remove duplicates.
› Before confirming, decide which columns identify the same record: matching email addresses do not make two different orders duplicates.
› Decide what one row represents I begin a cleanup by writing one sentence: “Each row represents an order,” or “Each row represents a customer.” This is the decision that determines which records should survive.
› The spreadsheet cannot infer your business meaning from the fact that two cells look alike.