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. Product homepage: http://office-excel.com/excel-addins/tables-transformer.html
VERSION HISTORY
- Version 1.3.3 posted on 2013-03-07
Support for Microsoft Excel 2013 has been added. - Version 1.1.4 posted on 2007-10-17
The consideration of cells format when transforming tables has been added.
Program Details
- Category: Business > Office Suites & Tools
- Publisher: MAPILab Ltd.
- License: Free Trial
- Price: $39.00
- Version: 1.3.3
- Platform: windows
EULA
License Agreement By installing and using the software product (hereinafter referred to as the SOFTWARE) you agree to all the terms of this License. If you do not agree to any of the terms of this License, then do not install and use the SOFTWARE. 1. All the rights for the SOFTWARE belong to MAPILab Ltd., and they are protected by the copyright laws of the United Kingdom of Great Britain and by international treaties. 2. The SOFTWARE is not free. The SOFTWARE is not sold, the SOFTWARE is licensed. By accepting this license agreement, you get the limited license for use of THE SOFTWARE within the trial period. Upon expiration of this license, you have to obtain the license for use of the SOFTWARE from MAPILab Ltd. or from its authorized representative. Otherwise you should stop using the SOFTWARE and remove its files from your machine. 3. This license agreement, as well as the SOFTWARE use license, gives you non-exclusive right to use the SOFTWARE with the limitations this agreement explicitly provides for. 4. You can distribute unmodified copies of the SOFTWARE without any limitations and without permission or license from the copyright owner. You can include the SOFTWARE into any software packages on floppy disks, CD-ROM or other medium, place it on an Internet site, or distribute it through other networks. 5. The license for use of the SOFTWARE gives you the non-exclusive right to install the SOFTWARE and use it on computers which number depends on the license type. If the SOFTWARE is installed in a local network for shared usage, the number of computers specified in the license should correspond to the number of the computers the SOFTWARE is launched on. License for use of the SOFTWARE doesn't impose any limitations on duration of the period of use (except for special limited trial use license); the license grants you a right to get updates of the SOFTWARE for free within one year and your right for technical support of the SOFTWARE within two years. The license for getting the SOFTWARE updates and technical support can be prolonged on advantageous terms. 6. The license for the SOFTWARE cannot be sold or transferred to third parties or leased without written permission of the copyright owner. 7. The license gives you no right for to modify, decompile, disassemble, and clone the SOFTWARE, except for the cases where such actions are explicitly permitted by the legislation of the United Kingdom of Great Britain and within the limits stated in such legislation. 8. MAPILab Ltd. gives no warranty that the SOFTWARE meets your requirements. The purpose of the limited trial license is to give you an opportunity to evaluate whether the SOFTWARE meets your requirements. After you obtain the license for use of the SOFTWARE, you can't claim any refund of its cost with the reasoning that the SOFTWARE doesn't meet your requirements or it used to meet them but doesn't any more. 9. MAPILab Ltd. is not liable for the loss of profit or any other damage occurred due to your use or improper use of the SOFTWARE. You use the SOFTWARE at your own risk. 10. MAPILab Ltd. reserves all the rights not explicitly stated in the license. 11. Failure comply with the provisions of this license agreement automatically results in termination of the SOFTWARE use license and may result in administrative and/or criminal prosecution. 12. By installing and using the SOFTWARE you accept the terms of the license agreement. If you disagree with any provisions of the license, remove the SOFTWARE files from your media and cease using it.