Combine Rows Wizardmerges data from multiple duplicate rows into one quickly and perfectly. It takes just 3 simple steps to combine all values from identical rows based on a selected key column or several columns. The wizard can join all entries or pull unique data only skipping duplicates and empty cells.
Here's what makes the Combine Rows Wizard stand out:
A handy wizard swiftly merges duplicate rows in the entire table or a selected range.
The wizard can merge only unique values ignoring duplicates and skipping empty cells.
You can choose one or several key columns as your unique identifier.
You can specify a different delimiter for each column you want to merge.
The add-in works with Microsoft Excel 2010 32-bit and 64-bit, 2007, 2003.
ExcelPipe Lite (+1 Yr Maintenance) - Automatically Find and Replace across Thousands of Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate... ...