Table.Transpose
TableTransposes the table so that rows become columns and columns become rows.
Syntax
Table.Transpose(table as table, optional columns as any) as tableParameters
| Name | Type | Required | Description |
|---|---|---|---|
table | table | Yes | The table to transpose. |
columns | any | No | Optional. Column names for the transposed result. Can be a list of names or a table type. |
Return Value
table — A new table where each original column becomes a row and each original row becomes a column.
Remarks
Table.Transpose rotates a table 90 degrees: each column becomes a row and each row becomes a column. The original column headers are not automatically preserved — they become the values in the first row of the transposed result (or the first column, depending on orientation). This means transposing almost always requires a follow-up step, typically Table.PromoteHeaders to elevate the first row into column names, or Table.DemoteHeaders to push original headers into data first.
The optional columns parameter controls the column names of the transposed output. Supplying it avoids the need for Table.PromoteHeaders by setting column names directly. If omitted, columns are named Column1, Column2, etc.
Table.Transpose is useful for pivoting "wide" month-column datasets into a "long" time-series format, or for converting a key-value column layout into a horizontal record. It does not fold to data sources, so for large datasets avoid transposing unless necessary. For more structured pivoting by dimension, consider Table.Pivot and Table.Unpivot instead.
Examples
Example 1: Transpose a monthly metrics table and promote headers
let
Source = #table({"Metric","Jan","Feb","Mar","Apr"},
{{"Revenue",100,200,150,300},{"Cost",50,80,60,120}}),
Transposed = Table.Transpose(Source),
Promoted = Table.PromoteHeaders(Transposed)
in
PromotedMetric | Revenue | Cost | |
|---|---|---|---|
| 1 | Jan | 100 | 50 |
| 2 | Feb | 200 | 80 |
| 3 | Mar | 150 | 60 |
| 4 | Apr | 300 | 120 |
Example 2: Transpose Employees table and supply column names directly
let
Subset = #table(
{"EmployeeID","FullName","Department","Salary"},
{{"E001","alice smith","Sales",55000},{"E002","BOB JONES","Engineering",95000}}
),
Transposed = Table.Transpose(Subset, {"Field","Employee1","Employee2"})
in
TransposedField | Employee1 | Employee2 | |
|---|---|---|---|
| 1 | EmployeeID | E001 | E002 |
| 2 | FullName | alice smith | BOB JONES |
| 3 | Department | Sales | Engineering |
| 4 | Salary | 55000 | 95000 |
Example 3: Round-trip: demote headers, transpose, and promote to reshape a wide table
let
Wide = #table(
{"CustomerName","Q1","Q2","Q3","Q4"},
{{"Alice",100,200,150,300},{"Bob",80,120,90,160}}
),
Demoted = Table.DemoteHeaders(Wide),
Transposed = Table.Transpose(Demoted),
Promoted = Table.PromoteHeaders(Transposed)
in
PromotedCustomerName | Alice | Bob | |
|---|---|---|---|
| 1 | Q1 | 100 | 80 |
| 2 | Q2 | 200 | 120 |
| 3 | Q3 | 150 | 90 |
| 4 | Q4 | 300 | 160 |