Combine data from duplicate rowsCombine Rows Wizard

Quite often we get Excel files where data was entered by different users. As a result, you may see several rows with information about one and the same item. But this is half the trouble. The main problem is that only some columns are filled with data in each duplicate row.

Combine Rows Wizard offers a quick and neat solution. This tool perfectly combines all values from duplicate rows into one based on the selected key column or columns. The wizard can join all entries or pull unique data only, omitting all duplications and empty cells.

Merge data from duplicate rows in 3 simple steps

• A handy 3-step 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.