Make table form data applicable for Excel pivot tables

Data Assistant for Excel in detail

The Data Assistant for Microsoft Excel helps you get your data into Excel Pivot Tables the right way. Frequently, data one receives from other software is not properly arranged. For example, it arrives in nice report format, with a column for January, one for February and so forth. The Data Assistant converts this into a data table for use in a Pivot Table. If your data looks like the following:

Data Assistant for Excel - source data

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.

The Data Assistant comes with a detailed help file to help you in the use of the Data Assistant. There is also a demonstration file that helps you learn how to use the Data Assistant. It is available by clicking on the button "Demo File" on the above dialog.

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..