When a table is created, Power Query assumes that all data belongs in table rows. However, a data source might have a first row that contains column names. To make sense of the data, you might need to promote the first table row to column headers. You promote a row in the Query Editor.
Learn more about the Query Editor
You can access the Query Editor from the Navigator pane when connecting to a data source, or at any time from the Workbook Queries pane or the contextual Query ribbon tab for an existing query. To learn how to load the Query Editor, see Power Query Quick Start.
Promote a row to column headers
Using the Query Editor ribbon
- In the Query Editor ribbon, click Use First Row As Headers.
Using the preview grid table icon ( )
- Right-click the table icon ( ) in the upper left corner of the table.
To Promote a row to column headers
- Select Use First Row As Headers.