Forum Discussion
Unpivot matrix
I am trying to make a current matrix of data. The matrix is currently set up such that the combination of % to quota (rows) and volume ranges (columns), results in a payout amount. I'm trying to find...
Thanks - for my own educational purposes, could you layout the steps that you went through to get to this result?
egspen2 If you are unfamiliar with PowerQuery, the link below would be a good place to start learning. In particular, chapter 13 deals with unpivoting data.