Tables Transformer for Excel

The Tables Transformer for Excel program allows you to quickly and easily perform the following conversions of Microsoft Excel tables: prepare table data for building summary tables; divide one table into several; combine two tables into one.

Data Conversion for PivotTables Microsoft Excel has a powerful and convenient means for presenting data in the form of pivot tables, however, for their correct creation, additional transformations of the original tables are often needed. Tables Transformer for Excele converts the original data and makes it suitable for building a pivot table.

Splitting tables Tables Transformer for Excel will divide the specified table into several, based on: the specified number of rows; unique cell values ​​in the specified columns. To divide an existing table into several different by a given number of rows, you just need to tell the program how many lines to start a new table and it will be instantly divided. The program can duplicate column names in each new table and place new tables on the current or new sheet, or in a new book. For example, you have a monthly sales report for the year and you need to get four quarterly reports. Set the separation interval - 3 lines and get four separate tables containing information on sales for the quarter.

Joining two tables into one Tables Transformer for Excel will join two tables into one, grouping the data together. For example, you have a table with the names of goods and their quantity and the second, containing the name of the goods, the delivery date, the supplier and the price. Use the join mode of tables with grouping by name, and you will get a table containing five columns: name, quantity, delivery date, vendor, price. This mode of operation allows you to choose which data to include in the general table, and which ones do not and choose the location of the new table. In this case, the original data remains unchanged.