Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Column stacking

rajat_del
7 - Meteor

Hi All,

 

I have a problem which i am stuck with.

 

I have basically three columns. 

 

Fruit_type   Cost  Country

Orange       100    America

Orange        200   UK

Orange        300    Australia

Pear             50    America

Pear             10    UK

Pear              30    Australia

 

I want it in a format so

 

 

Fruit type  America   UK    Australia

Orange      100         200     300

Pear            50          10       30

 

I tried cross-tab but it didn't work, is there a simple method to do this ?

2 REPLIES 2
binuacs
17 - Castor

@rajat_del  it should work with cross tab

 

binuacs_0-1639654627818.png

 

csmith11
11 - Bolide

Works for me as well: See solution attached. You should be able to copy the tool right into your workflow from mine.

csmith11_0-1639673354862.png

 

 

Labels