Comment on page
Table.Transpose
Makes columns into rows and rows into columns.
function (table
as table, optionalcolumns
as nullable any) as table
Makes columns into rows and rows into columns.
Table.Transformation
Make the rows of the table of name-value pairs into columns.
Table.Transpose(Table.FromRecords({[Name = "Full Name", Value = "Fred"], [Name = "Age", Value = 42], [Name = "Country", Value = "UK"]}))
Table.FromRecords({ [ Column1 = "Full Name", Column2 = "Age", Column3 = "Country" ], [ Column1 = "Fred", Column2 = 42, Column3 = "UK" ] }, { "Column1", "Column2", "Column3" })
Last modified 5yr ago