Table.DemoteHeaders

Moves the column headers, also known as column names, down to the first row of values. The initial column names are "Column1", "Column2", and similar.

Syntax

Table.DemoteHeaders(table as table) as table

About

Moves the column headers, also known as column names, down to the first row of values. The initial column names are "Column1", "Column2", and similar.

Explanation

Modify the header of the first row in the table using Power Query M. Use the MTable.DemoteHeaders function with the following table data: CustomerID, Name, and Phone for Bob and Jim. The output will display the values with the modified header in the table as follows: CustomerID, Name, Phone, with the corresponding values for Bob and Jim under each column.