Promote a row to column headers

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

  1. In the Query Editor ribbon, click Use First Row As Headers.

Using the preview grid table icon (Table icon)

  1. Right-click the table icon (Table icon) in the upper left corner of the table.

To Promote a row to column headers

  1. Select Use First Row As Headers.

Applies To: Excel 2013, Excel 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language