Replace column names of nested tables using Power Query | Excel Off The Grid

[@IvanCortinas_ES]

Again another great tutorial. The important thing is not to measure how much the person who tells it knows (who has a lot of knowledge), but to know how to tell it in a way that the public finds out. And that totally happens. Then goal accomplished. Congratulations Mark.

[@ExcelOffTheGrid]

Thank You Ivan - that’s very kind of you to say. I try to share my knowledge in a way that is accessible to others, so hearing that feedback has really made my day 😁

[@kebincui]

Excellent as always👍. Thanks Mark. You can save one step of promoting headers if in the first step if you set the second parameter to of Excel.Workbook to true, Excel.Workbook(File.Contents(FilePath), true, true).

[@ExcelOffTheGrid]

Good point. It one of those things I know, but rarely remember :-)

[@Bhavik_Khatri]

Excellent video.

[@ExcelOffTheGrid]

Thank you very much! 😁

[@MonikaFlight]

Hi great video, but in my power query I have an error that pq can't find the "Find" column and MissingField.Ignore is not working in this case. is there a way to bypass this?

[@thebhaskarjoshi]

Can we expect 30 most useful Excel Office Scripts to automating Excel tasks? Like the VBA pdf one.

[@ExcelOffTheGrid]

I’ve not got any plans for that at the moment. Due to the environmental differences between VBA and Office Scripts it’s harder to create universal code examples. The Office Scripts course includes a Power Automate code library, and 20+ pages of cheat sheets. So there is information out there, but the focus is different.