MAPILab - Microsoft Outlook Add-ins and Software for Microsoft Exchange Server
EnglishGermanRussian
You are here: Home / Add-ons for Microsoft Excel / Tables Transformer for Excel
Tables Transformer for Excel

Tables Transformer for Excel

Current version: 1.3.3
Click here for more screenshots

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.

Typical example of such a transformation:

Tables Transformer example add-in 1

Tables Transformer example add-in 2

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 report per one year and you need to get four quarterly reports. Specify an interval of division - 3 rows and get four separate tables containing sales information per a quarter.

Tables Transformer add-in example 3

Tables Transformer add-in example 4

The option of dividing the table according to unique values will allow you to create separate tables for each unique value of a cell. For example, you have a table which consists of three columns: type of a product, manufacturer and price. Using this option, you can get separate tables on each manufacturer.

Tables Transformer add-in example 5

Tables Transformer add-in example 6

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.

Download Trial Version

You can download a free trial version (10780 KB) of Tables Transformer for Excel and test it before purchasing:

Primary Download
Secondary Download

Ordering Information

A trial version of Tables Transformer for Excel has no limitations. But if you would like to use this software after the 20-days trial evaluation period a registration is required. You can order the fully licensed version of Tables Transformer for Excel over the Internet with any major credit card.

Pricing:

License typeUSD
Single user license    $39
5-Users license    $159
10-Users license    $249

Buy Now!

* If you are interested in purchasing more than 10 users licenses, volume prices are available here.

Click here to purchase the fully licensed version of Tables Transformer for Excel.

Download Tables Transformer for Excel Download a 20-days trial version of Tables Transformer for Excel (10780 KB):
 Primary Download
 Secondary Download
Purchase Tables Transformer for Excel Purchase Tables Transformer for Excel online through a secure server with any major credit cards.
Tables Transformer for Excel flash tours Look through the flash tutorial tours to learn more about our product workings and configuration settings
Product Home Page
Screenshots
Version history
Technical Details
Leave your Suggestion:
Name:
E-mail:
Search on MAPILab.com:

 

Get our Newsletter:

E-mail:

Quick links to MAPILab software:
Add-ons for Exchange
Add-ins for Outlook
Plugins for Microsoft Excel
Plugins for Outlook Express
Analytics for SharePoint
HelpDesk for SharePoint
Workflow Extensions for SharePoint
Content Migrator for SharePoint