Rename columns in Power Query when names change | Excel Off The Grid

Hi Mark, file download don`t work.

Hello, Thanks. I did the same but i get error!! Expression.SyntaxError: Token ',' expected.

= Table.RenameColumns(#"Promoted Headers",{{Table.ColumnNames(#"Promoted Headers"){6}, "maand 1"}, {Table.ColumnNames(#"Promoted Headers"){7}, "maand 2"}, {{Table.ColumnNames(#"Promoted Headers"){8}, "maand 3"}, {{Table.ColumnNames(#"Promoted Headers"){9}, "maand 4"}})

very useful

Wow, very cool trick that came in super-useful today. I was cursing some report writers who broke my workbook because they decided to change the column header names on a report that I've been using for 3-4 years. Thanks for this tip!

Excellent solution!! This is extremely useful. Thanks.

Awesome trick . Exactly what I was looking for . I like the later one . Thank you so much .

Wow...thank you for this. Both approaches are excellent.! Keeping this in my saved list.

Thanks for sharing ❤

I've been struggling with a similar case for a while. This just saved me! Thanks!

Can I do this with column selection? I have 15 columns, but only need to keep the first 6 and they will change their names quarterly. I tried using your M Query method but got an error saying that "value of type List can't be changed to type Function".

Great video!

This is brilliant 👍🙂 Love your content on power query. Please make more videos 😉

thx alot of these good Solutions and i want to explane how to skip dynamicaly empty columns or rows

Thanks for an amazing video. 💕💕💕💕

Another simpler solution could be to change type before, when the column are still standard named, just after the clear first 3 rows step, than after the change type step, you can promote the header without any further step .

Hi Mark. Awesome solutions! I've been looking for a way to do this. Love the direct edit of M code using Table.ColumnNames() with positional index operator. Brilliant stuff! Thanks for sharing these great techniques :)) Thumbs up!!

👍👍🌹🌹🌹🌹

Love all three methods.
Another way: If the structure is the same, with detect data types off, you can manually do actions which will reference 'Column1', 'Column2', etc and then promote headers afterwards, and this will keep the original names of the headers each period as you progress. This may be useful if you are 'pdf'ing the spreadsheets each week to keep an archive.