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.
This way you will be able to store all relevant records side by side, while also having your data beautifully presented.
Here are some key features of "Combine Rows Wizard for Microsoft Excel":
· 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
Requirements:
· .NET Framework 2.0
· Excel 2010 32-bit and 64-bit, Excel 2007, Excel 2003
Limitations:
· 15 days trial period