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