Tip of the Day | September 26, 2026

This tool reshapes data from a single column into table form by transposing your selected data in steps. It works by taking a specified number of rows from your column and converting them into columns.
This makes it easier to view and analyze large datasets that are originally in one long column.

For example, data from an older inventory system might export each product's details (product name, price, description, SKU) in one long column. Using this tool, you can group every four rows to form a structured table, where each row represents a complete product record.

Formulas and formatting are preserved, and you can set the number of rows to transpose per step to control the table layout.

Historical Note:
ASAP Utilities introduced this in 2001, long before Excel added the =WRAPROWS() function in 2022.

Starting this tool