Dear Excel Gurus,
Pardon one of your weaklings for asking your guidance on one of the quest to master Excel.
As you probably know, you need to make a table to be able to use the Power Query function.
I have lots of sheets with identical tables. Sheets are named based on my clients.
I am currently stuck with one of the Power Query "setting" - changing the header's name of a table.
Once I change it, the query goes error. I have to change it manually in the advanced editor menu.
And it is a pain in the butt to do that one-by-one when you have more than 10 tables in the workbook.
I have attached the example file for you.
Please be the knight in the shining armor for me and help me solve this issue.
Thank you.