Transpose
Flips a table so rows become columns and columns become rows (the same move as
Paste Special, Transpose in a spreadsheet). The first column of the result, named
Field, holds the original column names; each original row becomes a column
named Row1, Row2, and so on.
Inputs
| Input | Accepts | Required |
|---|---|---|
Table | Table | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Table |
Example
Your Summary table has one row per quarter and columns Quarter, Revenue,
COGS, Opex. Transpose it and you get one row per line item: Revenue, COGS,
Opex read down the Field column with the four quarters across, the layout most
income-statement reviews expect. The flipped table appears as its own tab.
Tips
- The generic
Row1,Row2headers can be renamed with a RenameColumns node (e.g. toQ1,Q2,Q3,Q4). - To summarize while reshaping, rather than only flipping, Pivot or Unpivot is usually the better tool.