Unpivot

Converts a wide table, where periods or categories sit as column headers, into a long list with one row per value. The columns you name as identifiers stay put; every other column collapses into two new columns, Variable (the old column name) and Value (the cell contents). Most charting, grouping, and forecasting works far better on this long format.

Inputs

Input	Accepts	Required
`Table`	Table	Yes

Outputs

Output	Produces
`Result`	Table

Settings

Typed in on the node or set by the assistant, not wired.

Setting	Default	Notes
`IdColumns`	—	Choose one or more columns from the connected table. Comma-separated columns to keep as identifiers on every output row (e.g. `Customer` or `Customer,Region`). Every column not listed here gets unpivoted.

Example

Your Budget table has one row per department with columns Department, Q1, Q2, Q3, Q4. Set IdColumns to Department. The result has four rows per department: Variable holds Q1 through Q4 and Value holds the dollar amounts. The long-format table appears as its own tab, ready to group by quarter or feed a line chart.

Tips

If the quarterly columns are all numeric, the Value column comes out numeric too, so downstream totals and charts work without extra steps.
To reshape the long result back into a grid, follow with a Pivot node using Variable and Value as its fields.