Rename a Column Using Power Query or Get & Transform
Excel in Office 365 has a new set of a feature known as Get & Transform. We will rename a column using it.It provides a platform to perform a series of steps to help you to transform your Excel data. There is one step which will allow you to take is to rename a column by using multiple methods.
You can also browse our Power Query Tutorial Catalog here.
NOTE 1: You can create random excel workbook online here for practice purposes as I did in this tutorial.
NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.
Previously in Power Query: How to perform Case Insensitive Filtering Using Power Query
STEP1. Firstly, select your data and press the shortcut Ctrl + T or by going to Insert > Table then it will turn into Excel Table.
STEP2. Now in the second step follow this procedure:
For Excel 2016: Go to Data > Get & Transform > From Table
For Excel 2013 & 2010: Power Query > Excel Data > From Table
STEP3. After completing the second step you will open up the Power Query Editor.
Now we will try our first method.
Before following this step make sure your first name column is selected in your excel or double click the column name also you can press F2 too.
We will change it to “Full Name“
STEP4. In the fourth step, we will show the second method of renaming.
So, right-click on that Last name column and select the Rename option.
STEP5. Now from home option-click the Close & Load,
this will open up a new worksheet in the excel workbook with all the updated records.
Now successfully you have your renamed columns.