Rename Multiple Columns with Power Query

Sometimes you get data from others that have columns that you'd need to change the name. If it's something you do once, using the Excel Find and Replace function is fine. But if it's something you're going to do multiple times or a recurring basis, you'd think that a VBA macro is something that will need to be written. And if you don't know VBA, this bulk automation process may seem out of reach. However if you have Power Query in your versions of Excel, it's actually quite easy to rename multiple columns at once with some nested M code functions.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[wayneedmondson]

Awesome Doug! Thanks for the lesson and steps. Thumbs up!!

[gauravbrham]

Basic problem solved with simple solution, thank you ☺

[einyv]

Exactly what I'm looking for thanks

[kevinjentes]

Can you do the two changes you made in one step?

[jazzista]

Doug. Thanks for posting this elegant solution using powerquery: This is exactly what i needed. Now, Question: What if you have more than 2 replacements . Lets say you have a " -" and also a " ( " and i want to replace it with a blank.

[nethikarnarendra]

How to deal with dynamic headers using power query? Is there any M code that auto detects headers dynamically (headers should be dynamically updated)?

[ubaidillahmuhammad]

nice. don't be stingi. put link workbook download