Search notes:

Power Query M formula language standard library: Table.PromoteHeaders

Table.PromoteHeaders(TABLE as table, optional OPTIONS as nullable record) as table
Table.PromoteHeaders uses the values in TABLE's first record to assign the column names for the columns of the remaining rows (and returns the table).

See also

Reading the data of an Excel Range with Power Query
The Power Query standard library

Index