Transpose vs cross tab

[EleniB]

Hi there,

I'm brand new to Alteryx and was wondering if anyone could help me with the transpose vs cross tab tools. i have tried to do it on my own but I am not succeeding. Attached is an example of how the data currently looks and how I would like for it to look.

any help woulld be greatly appreciated :)

thanks

Eleni

[Federica_FF · Accepted solution]

Hi,

in order to get what you desire you should use the cross tab, grouyng by id or a summarize

[EleniB]

thanks so much!!! exactly what i needed