Power QueryExercises

Promote headers

Turning the first row of a table into its column names, usually right after importing a CSV.

Header promotion should happen once, after banner rows are removed and before columns are referred to by name. Duplicate header names get a numeric suffix. The automatic Changed Type step that follows hard-codes every column name, so review it before relying on the query.

In the Power Query editor

Home → Use First Row as Headers, or Table.PromoteHeaders in the formula bar.

Learn more

Related functions

Practise it

Related terms