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.
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.
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.