NEW! FREE 1 hour Data Cleaning Course for Beginner Users Watch now 

Power BITutorials

How to Use First Row As Headers in Power Query

1 Mins read

One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take an example where you have the data set as shown below.

Use First Row As Headers By Power Query

Here, the headers are not meaningful as it is showing the headers as Column1, Column2, Column3 and so on. Therefore, we have to eliminate them and replace them with the first row’s text.


Here is the step by step guide to using the first row as headers by power query in excel. 

Step 1: Load the data table in Power Query Editor

     First load the data into the Power Query by clicking on

     Home tab > New Source button > Excel  > OK

     It will give you the data table in this form-


Step 2: To change the auto-generated table headers with the original table headers,

Use the ‘Use First Row As Headers’ option.

                     Go to Transform  > Use First Row As Headers option


Note: This option is also available on the ribbon of Home tab in the transform section


Step 3: Close & Apply

Now you get the data table with the new table header and thus you can carry out further operations with your data. Click on ‘Close & Apply’ option to apply the pending changes.


You can learn more :

If you want to learn more Power Query & its Functions, then check our latest online Power Query Course Training. This course comes with instructor-led videos with lifetime access. 

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…