![]() |
| Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
|
|
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.
|
|
| Copyright 2010 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |