Home » Excel » Create combinations from multiple lists – Cartesian product – Power Query

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? I prefer Power Query.

Download sample file and try.

Convert crosstab data to tabular – Excel | Power BI | Power Query

How to Convert EDL to Excel or Power BI in Power Query – Edit Decision List file for video editing

Instant data clean-up using Power Query in Excel and Power BI – no macros needed

Combine data from multiple Excel sheets or CSV / Excel files – Power Query – Power BI – ETL

Power BI in 15 min – 2020 – Power Query – Business Intelligence – Office 365

How to Import Tabular Data from PDF to Excel and Power BI

How to Import Tabular Data from PDF to Excel and Power BI – Part 2 – Data Analysis – Power Query

Join 1,747 other subscribers

Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.