![]() |
| Questions? E-mail us or call us 302-234-9857, 8AM to 10PM U.S. East Coast Time 7 days a week |
|
|
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 and Excel 2010. 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.
|
Order online. Order Risk Free
|
| Copyright 2011 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. |