Merging data from duplicate rows into one by key columns

Combine Rows Wizard for Microsoft Excel 2013-2003

Task

Your Excel table contains duplicates in the main column with IDs. You can't simply delete duplicates because different relevant data are spread over multiple rows. You want to get rid of the repeating IDs, yet keep all the rest.

Solution

Combine Rows Wizard for Excel merges duplicated rows based on the records in the column you select. You simply choose your table, pick the columns with the duplicate records, and enter the delimiter for the unique records that are pulled to one row.

Duplicate rows easily merged into one Excel record.

Combine Rows Wizard key features

Feel free to install this nifty Excel tool and use it whenever you need to join duplicated rows. Besides getting rid of identical data, you will have several useful options for the best results.

  • Combine duplicate rows by key column records
  • Specify a delimiter for merging unique values
  • Merge only unique data skipping dupes and empty cells

Tip

You can get this add-in as a part of Ultimate Suite for Excel - 20+ add-ins destined to cut your time and clicks on the most frequent spreadsheet tasks.

Combine Rows Wizard in detail

Combine duplicate rows based on unique records in the selected columns.
Enter or select the delimiter for the values you merge.

Combine Rows Wizard for Microsoft Excel is a perfect tool for those who need to get rid of duplicate values in one column, and get the relevant unique data for them on one row.

Suppose, you have an Excel worksheet where you have several rows of information for the same person, ID, and address. This helpful tool will remove multiple duplicate rows and it will keep all unique information listed for the given record. Forget about wasting your time on checking the spreadsheets for identical rows manually. This task is fully automated now!

Combine Rows Wizard supports all Excel versions from 2003 to 2013 and such Windows versions as Windows 8/7, Vista, and XP. If you need to install it to Server 2003-2012, it should be no problem at all. Terminal Server setup is available as well.

Merge duplicate rows by unique identifier

On the Select key columns step of the wizard you can pick one or several columns that contain duplicate records. These records are considered as unique identifiers. The add-in will combine identical values into one and put all remaining data for this value from different rows into one.

Specify a delimiter for merging unique values

The add-in will merge all unique records for the key values in the selected column(s). You can choose any delimiter to separate these values. You can benefit from selecting the default Semicolon, Comma, Space, Line break, or enter any custom delimiter you need.

Merge only unique records skipping dupes and empty cells

Combine Rows Wizard gives you the options to ignore empty cells and to Delete Duplicate values, which you can select on the final step of the wizard.

If the values referring to the same record that are being pulled to one row contain dupes, checking this feature will keep only unique values.

Thus you keep all relevant data on one row and have your Excel table beautifully laid out. 3 simple steps - and you get a duplicate-free worksheet, where all data for identical rows are accurately merged into one record.

29.95
Buy now

Combine Rows Wizard for Excel system requirements

Operating System

  • Windows 8 (32 and 64-bit)
  • Windows 7 (32 and 64-bit)
  • Windows Vista (32 and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework must be installed.

Microsoft Excel

  • Microsoft Excel 2013 (32 and 64-bit)
  • Microsoft Excel 2010 (32 and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Combine Rows Wizard for Excel version

Current add-in version: 2.0.2
published on: Apr 12, 2013

Order Combine Rows Wizard for Excel

29.95
Buy now
 
Contact us