|
||||||
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 2010-2021 and Office 365.
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. 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.
|
||||||
|