When a table is created, Power Query often automatically detects column headers and promotes them if necessary. However, you can also promote a first row to column headers or demote column headers to the first row when you need to.
Procedure
-
To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.
-
Do one of the following:
-
To promote the first row to column headers, select Home > Use First Row As Headers.
-
To demote column headers to the first row, select Home, select the arrow next to Use First Row As Headers, and then select Use Headers as First Row.
-