➤ Now, select the two cells containing Apple and go to Home Tab > Merge & Center Group > Merge & Center Option (or Merge Cells Option) You can easily merge the duplicates by using the Merge & Center or Merge Cells Option.Īt first, we have followed Step-01 of Method-1 to sort the product names from A to Z Method-2: Using Merge & Center Option to Merge Duplicates in Excel In this way, you will be able to merge the duplicate rows of the Product column and combine the names of the Salesperson according to the duplicate rows. ➤ Select the dropdown sign of the Helper column. Then, the filter signs will appear in every column of the table. ➤ Go to Home Tab > Editing Group > Sort & Filter Dropdown > Filter Option IF(FALSE,”useful”,””) → as the values are equal and so IF will return a BlankĪfter that, you will get useful for the duplicate rows. ➤ Go to Home Tab > Editing Group > Sort & Filter Dropdown > Custom Sort Option.Īfter that, it will sort the names of the products from A to Z In this section, we will use the IF function to merge the duplicates of the Product column and according to this, we will combine the Salesperson’s names for the duplicate products.įor this purpose, we have added two columns Combined Names, Helper. Method-1: Using IF Function to Merge Duplicates in Excel with Texts Here, we have used the following table to demonstrate the ways of merging duplicates in Excel.įor creating the article, we have used Microsoft Excel 365 version, you can use any other version according to your convenience. It can be helpful for a dataset containing a large number of duplicates to merge them and make the dataset clean and tidy.

If you are looking for some of the easiest ways to merge duplicates in Excel, then you are in the right place.

Duplicate data in excel