Hi everyone,
I am trying to create a matrix in the following format (Products x Criteria):
Matrix | C1 | C2 | C3 | C4 | C5 |
P1 | 5 | 8 | 9 | 2 | 9 |
P2 | 3 | 0 | 2 | … | … |
… | … | … | … | … | … |
The data that I have is all in various columns (about 2'000), in this format
P1_C1 | P1_C2 | P1_C3 | P1_C4 | P1_C5 | P2_C1 | P3_C2 | _P4_C3 |
5 | 8 | 9 | 2 | 9 | 3 | 0 | 2 |
In Excel I would use a Pivot Table on the original data, and separate it into the matrix using the getpivotdata formula.
Do you have any ideas how to do this matrix in Alteryx?
Thanks for any tipps!
Solved! Go to Solution.
Thanks so much. That worked perfectly!