Forum Discussion
Dynamic Months as Headers Help
Good morning all, Hope you are all well. I'm still very new to Power Query (I'm on Excel) and I have a document which has the headers Jan - Dec to simulate a full years worth of data, however, no...
adudani
Memorable Member
Memorable Memberhi Anonymous
could try either:
a. using dynamic list of column names to rename columns
b. using in the parameter of RenameCoulumns: "Missingfield.ignore"
Reference videos:
Dynamic Column Names in Power Query (youtube.com)
Dynamically Expand All Columns from Multiple Tables in Power Query (youtube.com)