Unpivot Excel data: columns to rows
Turn a wide table with one column per month or product into a long table a pivot table can use.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Unpivot data: columns to rows
- 1Select your file, or drop it on the page
- 2Run it — nothing to set up
- 3Download unpivoted.xlsx
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
What does unpivot mean?
It turns columns into rows. A table with Product, Jan, Feb, Mar becomes Product, Period, Value — one row per product per month — which is the shape pivot tables, charts and databases expect.
Which columns are unpivoted?
The columns of numbers. Text and date columns, like Product or Region, are kept on every row as labels. When the column headers are months or dates, the new column is called Period.
Do I need Power Query?
No. Power Query's Unpivot Columns does the same thing inside Excel; this does it from the file, with nothing to install.
What happens to empty cells?
They are left out of the result, so a month with no value does not become a row with a blank.

