Table.DemoteHeaders

About

Demotes the header row down into the first row of a table.

Syntax

Table.DemoteHeaders(table as table) as table  

Arguments

Argument Description
table The Table to modify.

Example

Table.DemoteHeaders(Table.FromRecords(  

{  

    [CustomerID=1, Name="Bob", Phone = "123-4567" ]  

}  

))  
Column1 Column2 Column3
CustomerID Name Phone
1 Bob 123-4567