Transpose PIVOT table with dynamic headings to a list

Hi,

Please find the step below, I run the same in EXCEL POWER QUERY, same you can run in POWER BI POWER QUERY

1. Load data into power query

2. Make sure QTY in the header (as below image)

3. Select the first column

4. Go to UNPIVOT COLUMN > Unpivot Other Column

5. Done, change the Column Header as per your requirement

Now see the result

Also if you want to advance the crosstab matrix table to a simple data table, please find a tutorial for referance -myaccountingtricks.com/2020/06/convert-crosstab-matrix-excel-list-data-table-unpivot.html, may it will help you.

If you find this is the solution, please mark as the solution and give kudos

Thanks
Pijush