Merging data from duplicate rows into one by key columns
Combine Rows Wizard for Microsoft Excel 2013-2003
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.
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.
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
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 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.
Combine Rows Wizard for Excel system requirements
- 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 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