Create a Cartesian Join with a Pivot Table

A Cartesian product is the product of two (or more) list. Say you have a list car types and a list of colors, what are all the possible combination of the values of both list. A small list may be easy to create with copy/paste. A larger list will take more time and this is where a Pivot Table might come in handy....check out the video to see how.
0:00 Intro
0:37 Create Tables
1:05 Create Pivot Table - Add to Data Model
2:20 Add Second Table to Data Model
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ 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 www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@Victor-ol1lo]

Cool trick Doug !! Sometimes a missing relationship can be a problemsolver.... :-)

[@DougHExcel]

Hi Victor Friesen, glad you liked it, thanks for commenting!

[@littlekidscartoonplanet]

must we pivots both of tables?

[@r.m.7743]

Great thanks

[@DougHExcel]

Hi Rebecca Moreno, thanks for the comment!

[@vudien2517]

Could you use power query in this case?

[@DougHExcel]

Yep! That video will be coming soon😀