Create combinations from multiple lists - Cartesian product - Power Query

preview_player
Показать описание
Learn two ways of combining multiple lists and creating all combinations.
Pivot table or Power Query. Both options work. I prefer Power Query.

Download sample file and try

Related Videos

Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------

Learn more from 1000+ blog articles by Dr Nitin Paranjape

Production
--------------------
Рекомендации по теме
Комментарии
Автор

I've been cracking my head with this! Thank you so much, so simple

deef
Автор

This is great but fails to permeate. Say modelling should be able to in the sets of 1, 2, 3, 4.
A use case will be for buying products say a, b, c, d. What are the possible patterns emerge as single like a double like ac triple line acb and quad like abcd; and its combinations. Can u pls show us?
As solution would it be thta each table has a value “blank”?

sajadabdulcader
Автор

This is simple, elegant and amazing. Putting table name in add column formula is just so simple and useful. 👍

canirmalchoudhary
Автор

is that 'm using excel for 20 years, but

saliyasamarajeeva
join shbcf.ru