Create Matrix For Output?

[LearningAlteryx1423]

Hi,

I have data in the following format:

Layer	Priority	Total # of tasks
1	1	22
2	1	32
3	1	12
1	2	34
2	2	1
3	2	4

Is it possible to create a matrix in Alteryx so that the layers are the x axis, the priority is the Y axis, and the total # of tasks fills the cells in between?

	Layer 1	Layer 2
Priority 1	22	32
Priority 2	34	1

I was trying to use transpose to achieve this but could not figure it out.

Thanks!

[geraldo · Accepted solution]

@LearningAlteryx1423 

Attached is a workflow.

I don't know if this is what you need.
needs some adjustments in column headings..

[LearningAlteryx1423]

Thanks!