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 column headers. Learn more at the Excel Help Center: https://support.office.com/excel