Data Assistant

A data related add-in product for Microsoft Excel

Do you have these problems:

• Need to effortlessly convert data from table form into a format suitable for pivot tables?
• Do you have a lot of data you need to use in pivot tables?
• Do you have data in the wrong format that you need to put into pivot tables?

The Data Assistant can solve all of these problems and more!

The Data Assistant for Microsoft Excel helps you get your data into Excel pivot tables the right way. It 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.