Data Management | Analytics

$ 19.99

Do you have a dataset that is intended to be a table but is organized in just one column? The XT Excel Data Reformatter Add-In is custom-created to help you turn your single column data into a versatile table format.

Once set up, the add-in will show in your Excel ribbon and you'll be able to turn single column data into a table with up to 100 columns.

This program works on either Mac or Windows -- all you need is MS Excel!

BONUS! The add-in also comes with a free bonus - you can highlight duplicate cells with the click of a button, instead of just deleting them.

Free Lite Version

While the Full Version allows you to select the number of columns you'll have in your table, the Lite Version comes with 3 pre-determined options:

Duplext: For data intended to be a two column table. Takes every other cell in the column and places it on the following column, then removing empty cells in the first column.
Triplext: For data intended to be a three column table. Takes every second cell, places it in a second column; takes every third cell, places it in a third column. Then removes empty cells in the first column.
Pentas: For data intended to be a five column table. Similar to Triplext, puts every second cell in a second column, every third cell in a third column, every fourth cell in a fourth column, and every fifth cell in a fifth column.

Please note: customer support is limited for Lite Versions

If you need to turn your column into a table with a different number of rows you can buy the full version once it becomes available. If you find that neither the Lite nor Full versions meet your needs, please contact us to talk about customization options.

By downloading you agree to our Terms of Use

Data Reformatter Excel Addin

Free Lite Version

Fill Out the Form to Download Now!