Convert field value to column names

[vshekharrc]

Hi team,

I am trying to convert values of a field as columns. Please see attached. My current table is Table 1. I want it in the format shown in Table 2. Could you please help me how I can achieve this in alteryx. I am not getting my head straight around this with transpose option.

Thanks,

Varun

[Luke_C · Accepted solution]

Hi @vshekharrc 

You could use a crosstab tool for this. Transpose would do the opposite. I suggest taking a look at some of the trainings in the academy, there's some really great content there on this.

https://help.alteryx.com/current/designer/cross-tab-tool

[vshekharrc]

Hi Luke_C,

Thank you for helping me on this. Yes, I am already onto the link that you have sent to learn more about it. Good day to you 🙂

Regards,

Varun