← Back to Table functions

Table.Transpose

Produces a new table by transposing the columns and rows of the original input table.

Syntax

Table.Transpose(table as table, optional columns as any) as table

About

Produces a new table by transposing the columns and rows of the original input table.

Explanation

Transform the rows of a table containing name-value pairs into columns using Power Query M function MTable.Transpose(). To achieve this, create a table with the name-value pairs and then transpose it. The resulting output will have the values in columns instead of rows.