Data Consolidator

An add-in for Microsoft Excel that consolidates many rows of data into a few.

Download a trial version now!
  • Easy to use
  • Menu driven
  • Convert many rows of data into a few rows
  • Great for combining test scores for data submission

The Data Consolidator add-in for Microsoft Excel makes consolidating many rows of data into a few very easy.

The following is an example of using the Data Consolidator to combine data into fewer rows:

Data before consolidation
Before - Notice two rows with data for Bauman and Campbell
Data after consolidation
After - Now just one row each. And the values on the second row have been moved to the first row.

The following is the main dialog of the Data Consolidator:

Data Consolidator main dialog
Main dialog

The entire process is menu-driven. The title columns can be any columns you wish.

The second option on the Data Consolidator, Combine cells on a row into one cell, will concatenate or combine cells into one cell. For example, the first and last names, which are in separate cells, can be combined into one. Or the scores, which are in separate columns, can be combined into one cell. You can use a space as a separator, use no separator, or specify any text you want to separate the combined entries. You can select multiple rows and multiple columns for combining.

Customers who viewed the Data Consolidator also viewed