fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Learn How to Rename A Column Using Power Query

One of the important and most needed features of Power Query is Renaming Column Headers. You can rename a column in Power Query very easily.

Rename A Column With Power Query

Let’s observe the below steps to rename column headers-

Step 1: Load Data in Power Query

When you load the data in Power Query, you will observe that the column headers are named as Column1, Column2 etc. The original column headers are placed in the first row as shown in the below picture. Therefore, we need to change the position of these column headers.

BEFORE CHANGING COLUMN HEADERS

Step 2: Use First Row as Headers

To use the first row as headers in Power Query, go to-

Transform  >  Use First Row as Headers  >  Use First Row as Headers option

USE FIRST ROW AS HEADERS

BECOME A BUSINESS INTELLIGENCE ANALYST COURSE
• Power BI • Excel to Alteryx • SQL Programming Language • SAS Programming • Tableau • KNIME • many more

 

Step 3: Close & Apply

As you can see in the below picture, the column headers are changed to the original column names. You can now click on the Close & Apply button to save the changes.

AFTER CHANGING COLUMN HEADERS

You can learn more :