Data Assistant An add-in product for Microsoft Excel Convert data in a nice looking report layout       to the data layout needed for a pivot table Handles data in different report layouts Lets you apply the power pivot tables to       better analyze your data Download a trial version now!

The Data Assistant add-in for Microsoft Excel helps you get your data into pivot tables the right way.  It is compatible with Microsoft Excel 2003, Excel 2007, Excel 2010 and Excel 2013.

The Data Assistant converts data that is in table form into data that is usable for pivot tables.  For example if your data looks like the following:

The Data Assistant will create a data table that looks like the following:     

The original data is not modified - a new table is created.  Data in the second format is the best format for pivot tables.

  The Data Assistant is completely menu driven.  The following is the initial dialog that appears:

Following this is the option to select the destination of the output:  to a new worksheet, a new workbook, or to any range location.

There is a help and exercise file that helps you learn how to use the Data Assistant.  It is available by clicking on the button "Help/Exercise File" on the above dialog.

View Cart US $29.95

Quantity
Discounts

Order online
Immediate
delivery

Money back
guarantee