Table.Transpose

About

Returns a table with columns converted to rows and rows converted to columns from the input table.

Syntax

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

Arguments

Argument Description
table The Table to modify.
optional columns Columns to transform.

Example

Table.PromoteHeaders(  

    Table.Transpose(  

        Table.DemoteHeaders(  

            Table.FromRecords({  

                [Name = "Full Name", Value = "Fred"],  

                [Name = "Age", Value = 42],  

                [Name = "Country", Value = "UK"]  

            })  

        )  

    )  

)  
Name FullName Age Country
Value Fred 42 UK