Rename all columns in a table at once using 'M' language and Power Query

[@momzwrite]

Was skeptical at first, glad I kept watching. Wonderful video, you're a really good teacher

[@Agile-Insights]

Thanks Tony 🙂

[@lukasreich2060]

Thank you! This saved me from manually renaming about 60 columns today. Really appreciate it.

[@rauljimenez5485]

3 incredibly useful elements in this video: The use of a 2nd date table to deal with multiple dates in the fact table, the approach to tinker with the code generated by the program and finally, a straigh forward solution to the issue. Thank you very much for sharing this!!!

[@wayneedmondson1065]

Great tricks.. both methods! Thanks for sharing them. Thumbs up!!

[@damionc]

Wow. Thank you so much. Both ToList and ToRows helped in solving my issue to create a custom sort order as well as bulk rename of columns using a table with the list of names.

[@SamehRSameh]

Great 👏👏

[@ajaaskelainen]

wow! I was wondering what can I do with Power Query and this has blown my mind! Thank you!

[@kwaaikraai]

Nice one! Thanks, Matt.

[@MarkCBB86]

Very helpful, Thanks Matt

[@raisingdemon]

You're a legend mate

[@sokgat7019]

Thanks Matt

[@veronicamuoio1455]

Hello! Thank you so much for this video! Very helpful to add text to a column. Could you do a follow up where you show how to remove text from multiple column headers? I have a dataset with 70 columns with a super-long introduction to each header that I want to delete quickly. If anyone knows please let me know!

[@msoffice6037]

Before typing new function name in the front of other function name put a space then when you hit TAB both functions stay on formula bar

[@stevennye5075]

That is an interesting solution

[@oleksiithonnessen5975]

didnt know this Table.ToRows function! I used to mimic this result by adding a custom column. It is like Table.ToList ( Table.SelectColumns( Table.AddColumn(#"Converted to Table","List",{[Column1],[Custom]}) , "List"))

[@defaultHandle1110]

Rename all columns dynamically using a list of columns generated from table.Columnnames(), then conditionally replace all values. Do a video. Or tell me how to email you. I have not found a solution to this need!