Transform

[Kjaer]

I have this format

and want this one

Can anyone help me?

[Luke_C · Accepted solution]

Hi @Kjaer 

You can use the crosstab tool:

[atcodedog05]

Hi @Kjaer 

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 : )

[surajmthomas]

The cross tab tool should help you transform your data structure into the desired output

[Kjaer]

Perfect. My problem is solved.

Thanks

[atcodedog05]

Happy to help : ) @Kjaer 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!