Tables Transformer for Excel 1.3.3
( View screenshot )
|This add-in for Excel 2000-2013 will allow you to fast and easy transform current tables to construct pivot ones, to divide one table into several ones or to unite two tables in one|
Mar 21, 2014 16:55:40|
|OS||Windows 98, Windows 2000, Windows XP, Windows 2003, Windows Vista|
click for full size
More author software:
- MAPILab Toolbox 3.0 A set of 18 "must have" Microsoft Outlook 2000/XP/2003/2007 add-ins for high-performance and useful functionality: you can schedule message sending; access files from your computer through email; manage your contact base; redirect your messages, and more.
- Duplicate Email Remover 2.15.0 Delete duplicate emails and posts in Outlook and Microsoft Exchange Server folders; search across your folders. A duplicate found can also be marked, copied or moved to any other folder. Works as an add-in for Microsoft Outlook 2000-2007. Free trial.
|Show all author software|
Tables Transformer for Excel 2000-2013 will allow you to fast and easy transform current tables to construct pivot ones; to divide one table into several ones or 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 tables.
Division of tables: Tables Transformer for Excel will divide the specified table into several ones on the basis of the specified number of rows or 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. The option of dividing the table according to unique values will allow you to create separate tables for each unique value of a cell.
Merging two tables in one: Tables Transformer for Excel will unite two tables in one with grouping of this data. For example, you have a table with names of the goods and their quantity and the other one containing the name of the goods, delivery date, supplier and price. Using this option, you can unite these 2 tables grouped according to the names of the goods. In the result, you will get a table containing 5 columns: name, delivery date, supplier and price. This option also allows you to choose the data to be included into a new table as well as to choose an arrangement of the new table. All the data remains unchanged.
excel, xls, format worksheet, excel software, multiple workbooks, excel add-in, format sheet, microsoft excel, excel download, excel 2013, Combine cells, excel 2007, worksheets, ms excel, excel 2010, spreadsheet format, excel add ins, merge tables, excel
Microsoft Excel 2000/XP/2003/2007/2010/2013, Microsoft .NET Framework version 2.0
The consideration of cells format when transforming tables has been added.
| Freeware alternatives Tables Transformer for Excel 1.3.3|
| Free Download Tables Transformer for Excel 1.3.3 from office-excel.com|