From Office Assistance LLC
Tables Transformer for Excel will allow you to fast and easy perform the following transformations of Microsoft Excel tables:
* To prepare tabular data for the construction of pivot tables.
* To divide one table into several ones.
* To unite two tables in one.
Data transformations for the construction of pivot tables
Microsoft Excel has a powerful and convenient means of data presentation in the form of pivot tables. However, additional transformations of initial tables are often necessary for their creation. Tables Transformer for Excel will transform initial data and will make it suitable for the construction of the pivot table.
Division of tables
Tables Transformer for Excel will divide the specified table into several ones on the basis of:
* The specified number of rows;
* Unique values of cells in the specified columns.
To divide the current table into several ones on the basis of the specified number of rows, you have to specify the number of the row from which a new table starts and the table will be immediately divided. The program can automatically copy names of columns in each new table and place new tables in the current or new worksheet. For example, you have a monthly sales
Microsoft .NET Framework version 2.0, Microsoft Excel 2000/XP/2003/2007/2010 Beta