Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.Transpose

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

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

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

Arguments

ArgumentDescription
tableThe Table to modify.
optional columnsColumns to transform.

Example

Table.PromoteHeaders(  
  
    Table.Transpose(  
  
        Table.DemoteHeaders(  
  
            Table.FromRecords({  
  
                [Name = "Full Name", Value = "Fred"],  
  
                [Name = "Age", Value = 42],  
  
                [Name = "Country", Value = "UK"]  
  
            })  
  
        )  
  
    )  
  
)  
NameFullNameAgeCountry
ValueFred42UK
© 2018 Microsoft