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