Table.DemoteHeaders
Demotes the column headers to the first row of values.
function (table
as table) as table
Demotes the column headers (i.e. column names) to the first row of values. The default column names are "Column1", "Column2" and so on.
Table.Column operations
Demote the first row of values in the table.
Table.DemoteHeaders(Table.FromRecords({[CustomerID=1, Name="Bob", Phone="123-4567"],[CustomerID=2, Name="Jim", Phone="987-6543"]}))
Table.FromRecords({[Column1="CustomerID", Column2="Name", Column3="Phone"],[Column1=1, Column2="Bob", Column3="123-4567"],[Column1=2, Column2="Jim", Column3="987-6543"]})
Last modified 4yr ago