Power Query
published
Search
K
Comment on page

Table.DemoteHeaders

Table.DemoteHeaders

Demotes the column headers to the first row of values.
function (table as table) as table

Description

Demotes the column headers (i.e. column names) to the first row of values. The default column names are "Column1", "Column2" and so on.

Category

Table.Column operations

Examples

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"]})