Merge duplicated rows with Combine Rows Wizard for Microsoft Excel

Combine Rows Wizard for Microsoft^® Excel^®

Combine data from duplicate rows in Microsoft Excel 2010 – 2003

For Microsoft Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003.

Merge data from duplicate rows

Combine Rows Wizard for Microsoft^® Excel^® add-in will join rows that refer to the same record in your table. Basically it combines duplicate rows based on the selected key columns and pulls the rest of the information onto the same line. Thus you keep all relevant records side by side and have your data beautifully laid.

Excel before and after Combine Rows Wizard

Just reap the add-in's harvest

We often share workbooks with our colleagues. When you get the file back from yet another department, you may see several rows with information about one and the same customer. But this is half the trouble. The main problem is that the financial dept. entered the payment info, the customer service department input the date of their last requests, etc.so only some columns are filled with data in each duplicate row.

The Combine Rows Wizard plug-in will quickly remove multiple duplicate rows in the columns you select and join the unique records into the appropriate cells.

3-step solution

Choose unique identifier columns
with duplicate values

Whatever you used to do with such set of data before – run through lots of manipulations and formulas or give up the task as hopeless, there are 3 simple steps that do it all now:

1. You select the table
2. Choose the key columns with duplicated data
3. And specify delimiters for merging data in other columns.

As a result, you get a clear worksheet free from repeated entries, where all data from duplicate rows are accurately merged into one row.

Rip the full benefits

Enter or select the delimiter for the
values you merge

If you want to introduce proper order in your Excel tables, you are in the right place:

• Combine Rows Wizard offers a simple 3-step process for combining rows in the entire table
• You can select the range with the duplicated rows
• Define the key columns that have duplicate values
• It allows you to merge only unique values in the remaining columns and delete duplicates
• You can choose to skip empty cells if you have any

Download now and see how it can help you