When a table is created in Excel, 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. Learn more at the Excel Help Center: https://support.office.com/excel
Copilot
VIDEO
16 October 2019
Promote a row to a column header in Excel
When a table is created in Excel, 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...
