Create combinations from multiple lists - Cartesian product - Power Query

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
efficiency365.com/wp-content/...
Related Videos
Convert crosstab data to tabular - Excel | Power BI | Power Query - • Convert crosstab data ...
How to convert a MM-DD-YY date to DD-MM-YY in Excel \ Power BI - Power Query #shorts - • How to convert a MM-DD...
How to Convert EDL to Excel or Power BI in Power Query - Edit Decision List file for video editing - • How to Convert EDL to ...
Instant data clean-up using Power Query in Excel and Power BI - no macros needed - • Instant data clean-up ...
Combine data from multiple Excel sheets or CSV / Excel files - Power Query - Power BI - ETL - • Combine data from mult...
Power BI in 15 min - 2020 - Power Query - Business Intelligence - Office 365 - • Power BI in 15 min - 2...
How to Import Tabular Data from PDF to Excel and Power BI - • Import PDF to Excel -...
How to Import Tabular Data from PDF to Excel and Power BI - Part 2 - Data Analysis - Power Query - • Import from PDF to Exc...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency365.com/bk
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency365.com/ptyt
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365.com/blog
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envato.com/
Created using Adobe Premiere: www.adobe.com/in/creativeclou...
AI based captions: videoindexer.ai (Microsoft service)

[@praveensinghtomar3777]

Superb

[@efficiency365]

Thanks @praveensinghtomar3777
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - czcams.com/video/rtDlORLmjlE/video.html
Excel Green Marks - Error Checking - Best Practices - czcams.com/video/XeLtlzd9lRY/video.html
Excel Best Practices - Part 1 of 3 - Data Management - czcams.com/video/rr_1ha6g6lc/video.html
Excel Best Practices - Part 2 of 3 - Formulas - czcams.com/video/kz_zAvMINAk/video.html
Excel Best Practices - Part 3 of 3 - Analytics - czcams.com/video/JNR5yx_Pg4A/video.html
10 Excel Settings You Must CHANGE! - czcams.com/video/vXrrXdKyJFk/video.html
Automatic data clean up with Excel Flash Fill - czcams.com/video/N3p_x_lXT_c/video.html
Instant Excel Audit, Comparison and Analysis - Inquire - czcams.com/video/cDdvUZxOUis/video.html
Six powerful Excel Navigation Shortcuts - czcams.com/video/bR-yMbGPq50/video.html
Handle millions of rows in Excel - Slow to fast - czcams.com/video/93h7rRsLF7Y/video.html
Convert crosstab to tabular - Unpivot - Excel Power Query - czcams.com/video/mTtOtZH-nNM/video.html
Cheers.
Doc

[@canirmalchoudhary8173]

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

[@efficiency365]

Yes. I also learnt it recently. Power Query is extremely flexible and versatile.

[@saliyasamarajeeva3983]

is that excel..... 'm using excel for 20 years, but never.....

[@efficiency365]

Thanks @saliyasamarajeeva3983
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - czcams.com/video/rtDlORLmjlE/video.html
Excel Green Marks - Error Checking - Best Practices - czcams.com/video/XeLtlzd9lRY/video.html
Excel Best Practices - Part 1 of 3 - Data Management - czcams.com/video/rr_1ha6g6lc/video.html
Excel Best Practices - Part 2 of 3 - Formulas - czcams.com/video/kz_zAvMINAk/video.html
Excel Best Practices - Part 3 of 3 - Analytics - czcams.com/video/JNR5yx_Pg4A/video.html
10 Excel Settings You Must CHANGE! - czcams.com/video/vXrrXdKyJFk/video.html
Automatic data clean up with Excel Flash Fill - czcams.com/video/N3p_x_lXT_c/video.html
Instant Excel Audit, Comparison and Analysis - Inquire - czcams.com/video/cDdvUZxOUis/video.html
Six powerful Excel Navigation Shortcuts - czcams.com/video/bR-yMbGPq50/video.html
Handle millions of rows in Excel - Slow to fast - czcams.com/video/93h7rRsLF7Y/video.html
Convert crosstab to tabular - Unpivot - Excel Power Query - czcams.com/video/mTtOtZH-nNM/video.html
Cheers.
Doc