Dynamically expand table column in Power Query

[@jeremy_317]

Thank you! Just what I needed to make sure newly-processed data merge correctly with prior date ranges (always expanding with new data)

[@GlastoX]

Dude, I was looking for something like this now in 2023, I asked chatGPT and it made me waste 3 hours with wrong codes, this explanation fixed everything in just 15 min. Thanks!

[@vacilando86]

You really saved my life with that training video. Thank you so much my friend.

[@ExceedLearning]

Glad it helped! :)

[@BaronVonReich]

Thankyou very much, you are very patient in the way you explain and is easy to understand by all levels of expereince

[@EricRamos42]

Great walkthrough and explanation!

[@spilledgraphics]

Excellente video mate! well done, well explained. The intro was very inviting to watch the rest of the tutorial! 👌👌👌

[@ExceedLearning]

Thanks! Glad you enjoyed it 😊

[@argokusumandani9773]

Thank you Sir. I hope can learn a lot of power query from you👍

[@ExcelUpNorth]

Awesome solution! This is exactly the answer I was looking for. Thanks! 😁

[@jessontvarghese327]

This is very much clear and nicely explained. Thank you so much for this video. Much appreciated. Also would like to mention that, audio volume is bit low, and the video focusing is also have some problem. Unable to see the text on the screen as it appears like lack of focus.

[@ExceedLearning]

Thank you Jesson! We strive to make every subsequential video better, so thank you for your feedback

[@zax8704]

You saved the day, thank you!

[@YvesAustin]

Very good video and great tip!

[@DinoAMAntunes]

Hi, Very good. Please i am Trying to find an example for Cartesian Product in Power Query. Multiple tables with multiple column in the same workbook, with some equal transformation and some diferents. Any example please. Tks in advance

[@ExceedLearning]

Hi, Unfortunately, we do not have the example for Cartesian Product. You might find this article helpful: radacad.com/cartesian-product-in-power-query-multiply-all-sets-of-all-pairs-in-power-bi

[@DinoAMAntunes]

@@ExceedLearning Yes thank you very much, but is to simple for my especific case.

[@cobusolivier2682]

Thanks for this explanation. I have created a function that will do this step: (Source as table, fieldName as text) => let /* Source = #"Input (GroupBy)", fieldName = "myTable", //*/ #"Expanded myTable" = Table.ExpandTableColumn(Source, fieldName, List.Skip( Table.ColumnNames(Table.Column(Source, fieldName){0}), 1), List.Skip( Table.ColumnNames(Table.Column(Source, fieldName){0}), 1)) in #"Expanded myTable"

[@Eaglegamer999]

Hello Sir, Please help me on my query. I have changed column header based on list it is working but not working in power bi dashboard. When i update source list then header has been changed in table but visual throwing error like" This can not be used it is invalid column". How can i fix it. Please reply me. Thanks

[@jerrydellasala7643]

I just found your channel. You're producing great videos on PQ, and know what you're doing! That said, I always find videos easier to follow when the data used in the video is available - at least the final product if not both the starting point (like without queries) and end product. I just started to follow you on LinkedIn. Feel free to contact me if you have any questions.

[@zzzzzzzzzzzzzzzz9]

Thanks I'm new here

[@brunof.s.8186]

Super useful! I was wondering how can I apply this not to a single table, but a table full of tables? Like: [Content] [Table] [Table] [Table] (…) Probably it should use Table.TransformColumns along with Table.ColumnNames, but i cant figure it out.

[@ahmadch70]

Hi, I am trying to watch the video but the data and formulas are blurred.

[@malchicken]

Much appreciated, thank you! I thought there was an interesting alternative solution presented by kzbin.info/www/bejne/noqZgWiDmaigsM0 recently. But your code extracts the column names from the start and avoids combining whole tables, so it seems like it would be better for performance. I like how your removed potential repeat headers in this videos solution as well with List.Skip. I think thats missing in the blog and the 'increased complexity' solution could use something similar to check for 'columns already present to remove or not expand out'. Also related: kzbin.info/www/bejne/mqu9qn-XeL1nrM0 I enjoyed this videos description of how to use List.Zip to easily create a list of lists for the old column names to the new columns names in the Table.ExpandTableColumn argument.

[@spilledgraphics]

@Hendrick McDonald, thanks for ALL the links and your comments.