Sunday, October 3, 2021

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.

No comments:

Post a Comment