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

Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.

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

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.