Tables Transformer for Excel 2000-2007 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.
Compare Spreadsheets for Excel 1.1.5
A powerful and convenient add-on for comparison of MS Excel 2000-2007 files. Compare Spreadsheets for Excel is a powerful and convenient tool for comparison of files in Microsoft Excel. How it's work: 1. Start the program (there is even no need to open the tables to be compared). 2. Specify the tables or ranges of cells to be ...
Similar Data Finder for Excel 1.1.4
This add-on helps you to find cells with similar values in Excel worksheets. Similar Data Finder for Excel will help you to find cells with similar values in Microsoft Excel 2000-2007 worksheets. The program enables you to quickly find mistakes made while entering cell values; easily correct the mistakes; find and mark cells which ...
Advanced Consolidation Manager 1.1.0
Add-on for advanced table merging and data consolidating in MS Excel 2000-2007. Advanced Consolidation Manager is designed for merging tables and consolidating Microsoft Excel data. In comparison to a standard data consolidation in Microsoft Excel, Advanced Consolidation Manager will allow you to process any number of files per one ...
Remove Duplicates from Excel 1.1.4
The add-on is designed for searching and processing duplicates in Excel tables. Remove Duplicates from Excel is designed for searching and processing duplicated cells in Microsoft Excel tables. Program key functions:
1. Search across columns and rows.
Remove Duplicates from Excel allows you to find duplicated cells in rows or ...
Merge Tables Wizard for Microsoft Excel 1.6.9
Lookup and copy matching data from one Excel worksheet to another. With this handy plugin you can easily lookup and copy matching data from one Excel table to another. Two tables can be located in the same or two different Microsoft Excel files. The intuitive and user-friendly interface of the wizard makes the join process ...
MAPILab Find and Replace 1.1.1
This add-on is an advanced version of the "Find and Replace" function in Excel. MAPILab Find and Replace for Excel is an advanced and extended version of the "Find and Replace" function for processing data in Microsoft Excel.
In comparison to the standard "Find and Replace" function, MAPILab Find and Replace for Excel has a number ...
4TOPS Compare Excel Files 2.0
Program to compare excel files gives easy to interpret reports using HTML 4TOPS Compare Excel Files is an easy to use program that clearly reports where and what the differences between two Excel workbooks are. features: - Easy to interpret reports using HTML; - Differences in the Analysis report and Visualization reports are ...
Fuzzy Match 1.5
Excel add in tool that evaluates cell contents and returns probability of match Microsoft Excel tool that evaluates the contents of two cells and gives a probability of a match; a value between 0 and 1 is returned. Easy to use custom function works just like any other Excel formula. Works with Excel 2000 2002 2003 2007. ...
Worksheet Search 2.0.1
Excel add-in that adds fast sheet search and activation using wildcard. Worksheet search and activation add-in for Microsoft Excel. Worksheet search integrates into the Excel toolbar and adds a quick worksheet search using sheet name or a wildcard. The main purpose of the add-in is to help people using Excel workbooks with ...
Create PDFs 1.3
Easy to use tool automatically converts all Excel files in a folder pdf format Easy to use tool that automates the creation of pdf documents. Create PDFs converts all the Excel files in a selected folder to PDF format. No need to open each file manually. Uses the free Microsoft pdf writer. Works with Excel 2007. ...
