I have this format
and want this one
Can anyone help me?
Hi @Kjaer
You can use the crosstab tool:
You can use crosstab like below
Here is a resource on the same https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876
Hope this helps : )
The cross tab tool should help you transform your data structure into the desired output
Perfect. My problem is solved.
Thanks
