- In short
- Reshapes a wide table into a long one on a new sheet, turning columns into rows so the data is easier to filter and summarize. You keep the id columns you choose. Your original data is not changed and this runs inside Excel. A new long-form sheet. Your source data stays unchanged.
What it is for
Unpivot Columns is used to reshape a wide table to long (attribute/value) form.
When to use it
It earns its place whenever you have to flatten month-in-columns data for a PivotTable/BI.
Example scenarios
- Flatten month-in-columns data for a PivotTable/BI.
What it needs
A table and an options dialog (id cols, unpivot cols, attribute/value names, include-blanks); estimate >1,048,575 refused. Supported data types: text, number, date (by selection).
How to use it
- Select the range to summarize.
- Run Unpivot Columns from the Summarize & Prepare group on the XLMind Plus tab.
- Adjust the options in the window to fit your case.
- Confirm; a new long-form sheet.
What it produces
A new long-form sheet.
Effect on your data and undo
Unpivot Columns does not change your source data; the result is added as a separate item.
How it differs from similar tools
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
Size limits (>1,048,575 refused.).
Limitations
Size limits (>1,048,575 refused.).
Frequently asked questions
- Where will I see the result?
- A new long-form sheet. Nothing is written on the sheet holding your source table.
- What happens to invalid or unexpected values?
- Row-estimate guard.
- How are blank cells handled?
- Optionally included.
- Does the result stay linked to the source?
- No, the output is static; rerun the tool after changing the source data for a current view.
- Any known limits?
- Size limits (>1,048,575 refused.).
Works well with
- As a preparation step, try Group By
- To keep working on the result, use Split Data
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.