Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert Single Column to Multiple Columns

ARHWAN0
6 - Meteoroid

Hi,

 

Trying to convert a single column to multiple columns using the Cross Tab tool, but having trouble getting to the desired result.

 

Source:

ARHWAN0_0-1750094159714.png

 

Desired Result:

ARHWAN0_1-1750094206526.png

 

Each value in the Description column needs to be converted into a separate column (each Description value ends up becoming a column header).

 

Any help would be greatly appreciated! 

4 REPLIES 4
abacon
13 - Pulsar

@ARHWAN0 Try this workflow, it gets the desired output.

 

Bacon

 

image.png

binu_acs
21 - Polaris

@ARHWAN0 The cross tab tool should work

image.png

ARHWAN0
6 - Meteoroid

Thank you @binu_acs, that worked!

ARHWAN0
6 - Meteoroid

Thank you @abacon , this solution also solved the problem!

Labels
Top Solution Authors