Скачать или смотреть Create All Possible Combinations from Two or More Lists in Power Query

If you have two or more list and wanted to figure out all the possible combinations of the items of those list, it would be called a cross join, many to many join or a cartesian join. This can actually be done easily with Power Query. It shouldn't take too long if your source list are small. But if your list are bigger, you could potentially have output that could be a table of several million rows or records. If you know Excel, it does support 1M+ records in a single worksheet, but not over 2 million records. An example in this video will cover 4M+ records but the workaround is to separate the records into a million each and put all of it into a text file. See the video to learn how generate all possible combinations from two or more list.


🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to   / doughexcel  

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~