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

Alteryx_question.PNG

Luke_C

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