How I Dynamically Transform Column Names With Power Query

[@antonysovy5887]

amazing as always

[@alejandrahorvath]

Thank you Antony! Glad you liked it 😊

[@kebincui]

Awesome, thanks 👍❤

[@alejandrahorvath]

Glad you liked it Kebin! Thanks for watching 😊

[@djerikgerst12]

great! thank you.

[@alejandrahorvath]

You're very welcome! Thanks for watching 😊

[@sebfromgermany3819]

Hola Alejandra, Este video es bonito :) 🎉Is there reason you didn‘t use Table.ColumnNames and the usual commands to manipulate the column name list? The new column name list could be used to update the headings in the nested tables (Table.RenameColumns) and potentially used to expand the nested tables. I can’t say why, but the skipping and transforming of tables to manipulate the headings looks complicated - even if it is straight forward and easy to understand. Cheers, Seb

[@alejandrahorvath]

Hi Seb, thanks for your message. Fortunately, there are different ways to process similar transformations. I find this technique useful, that's the reason why I presented these transformations. Feel free to share your solution in the comments, so we all can learn from it. 😊 Thanks for watching 😊