How to create a pivot table in alteryx

[pryia1234567]

In excel when you pivot off data you have the option of putting the fields in either "rows", "columns" or "values". Our current data has segments listed in one field. We want the data to group the segments and show it in separate columns. In excel this would be done by dragging the field to the "columns" section. How can I accomplish this in Alteryx? 

Thanks,

[Luke_C · Accepted solution]

Hi @pryia1234567  - check out the crosstab tool

https://help.alteryx.com/2021.4/CrossTab.htm

[binuacs]

@pryia1234567 Can you provide a sample input file and the expected result?

[grazitti_sapna · Accepted solution]

@pryia1234567 you can use cross tab tool for performing this task. you can check the details about this tool on below link. Sending you the configuration as per your requirement.

https://help.alteryx.com/2021.4/CrossTab.htm