Power Query - Advanced Dynamic Expansion of Tables

[@espeece23]

What’s up Sensei! You’ve helped me immensely convert to using the advanced editor in place of dialog boxes in PQ! Thanks. Your comment for the “I hate when it does that, it adds a double table!” Don’t type the dot next time, just tab the selection and it doesn’t add the double. Just one thing I noticed and figured I could help the master! Thanks again

[@kebincui]

Super! Thanks for sharing👍👍

[@moisestatis5418]

thank you SO MUCH. I was needing this badly. Honestly, I did not understand very well the last part, but I was able to make it work.

[@tterrabend]

This is sooo good! Thank you! 🙏

[@KoolGuyism]

I have a huge data base in json file format. There are a lot of lists and records and many lists and records contain more list and records in it. Its a tiring and irritating task to expand more than 50 lists and records manually one by one. This also creates a lot of duplicate records. So, How to expand multiple lists and records together in power query.?

[@catinugraha5300]

Cool !!!