merge duplicate rows in excel without losing data

It simply deletes the duplicate records from the cells (without disturbing cells around the dataset) Also read: How to Highlight Duplicates in Google Sheets Remove Duplicates using the UNIQUE function This means that using it doesn’t remove the rows or delete any cells. When you use the ‘Remove Duplicates’ option to get rid of the duplicate records, it wouldn’t impact the data around it. The above steps would instantly remove all the duplicate records from the dataset and you would get the result as shown below. Click on the ‘Remove duplicates’ button.

Make sure ‘Select All’ is selected (in the ‘Columns to Analyze’ section).In the Remove Duplicates dialog box, make sure ‘Data has header row’ is selected (in case your data has the header row).Select the dataset from which you want to remove the duplicate records.Suppose you have a dataset as shown below and you want to remove all the duplicate records from this dataset.īelow are the steps to remove duplicates from a dataset in Google Sheets: Removing duplicates is such a common thing people do in Google Sheets, that there is now a dedicated option to quickly remove the duplicate records.

Remove Duplicates using the UNIQUE functionĭelete Duplicates Using the ‘Remove Duplicates’ Tool.

Delete Duplicates Using the ‘Remove Duplicates’ Tool.

Merge duplicate rows in excel without losing data