Create table from existing data set in power query excel

Hello 10500438 

Select every column except the last one --> Tranform --> Group by 

Set the group by like this

change the formula in the formula bar the part of the funciton like this

each List.Product([Unit Yield])

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy