Data Conversion Tools with Add-ins/plug-ins for Excel

Report Inverter for Microsoft® Excel® 

Tools and Features

TOOLS TO CONVERT REPORT LAYOUTS FEATURES

 

Transpose Data Labels

This tool allows the transposition of data blocks vertically aligned on columns and separated by one or more rows (as labels do on a sheet of paper) creating a flat table structure. Each block of original data will occupy a row (record) of the output data.

more information 

Transpose Cross Tables

It allows you to transpose data lined up on rows in a cross table, moving them in a single column having as a result a table in flat file database format.

more information 

Line Up Multi-line Records

By using this tool it is possible to integrate in one single row all those records containing fields below in one or more adjacent lines.

more information 

Reply Headers & Footers

This tool allows you to replicate headers or footers, flagging the detail records of the report format. One or more columns are inserted to the right side of the data area, where selected cells of the header or footer are being replicated.

more information 

Replicate Group Fields

By using this tool it is possible to replicate downward, on the same column, those fields that appear as field group’s statements, embodied in the report’s detail.

more information 

 

TOOLS TO SEARCH/FIND AND REFORMAT DATA

 

Find Data & Extract Data Types

This tool allows the reallocation/moving of cells containing data on the same Excel worksheet, based on conditions established by the user on the basis of a user criteria.

more information 

Find Data to Delete Rows

This tool is useful in deleting all those rows containing text that matches the selection of one or more cells, offered by the user as a sample.

more information 

Find Data Pattern to Shift Cells

By means of this tool it is possible to shift one cell or set of cells located within a given range of data and with a recurrent data pattern in the datasheet.

more information 

Find Data Pattern to Insert Rows

This tool is useful while inserting one or more empty lines above or below a data pattern selected by the user and that recurrently appears on the Datasheet.

more information 

 

TOOLS TO REFORMAT

 

Delete Blank Rows & Columns

This tool is useful while deleting empty rows or columns. In the case of rows it allows you to establish a range of contiguous lines to be removed.

more information

Unmerge and Replicate Cells

With this tool it is possible to unmerge sets of combined cells. The text contained in each original set of cells will be replicated in each of the out coming separated cells.

more information

Encode Colors

It assigns a numerical code to each selected cell, according to its Foreground Color. For such purpose a column is inserted to the right side of the selected column.

more information

 

TOOLS TO TRANSFORM DATA

 

Split Text to Columns

This tool is useful while splitting texts contained in the cells of a single column, using one or more delimiters.

more information

Split Text to Rows

It allows you to split text contained in the cells of a single column and vertically transpose separated fields on the rows of such column, replicating cells with data that go along with each original cell of the split column in the selected adjacent columns as part of the entire data area.

more information

Concatenate Columns

By using this tool is possibly concatenate (join) fields originally located in independent columns that might be contiguous or separated. You may select a delimiter of your choice.

more information

Pad out with Leading Zeros

This tool allows you to insert zeros to the left side of numerical values until completing the length of the field established by the user, for which zeros will be added as needed.

more information

Trim Spaces within Cells

With this tool it is possible to remove extra spaces at the beginning and at the end of cells containing data (leading and trailing spaces).

more information


Copyright © 2008-2017 Databilio. All rights reserved.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation
in the United States and/or other countries.
 
Secure Purchase


Buy NOW

Buy Report Inverter for Excel