In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Group data in rows and transpose to columns

gmurali
6 - Meteoroid

Please let me know a solution or ideas for the the below operation - 

 

gmurali_1-1599556653339.png

 

Any idea or help would be much appreciated. Thanks in advance! 

 

5 REPLIES 5
JosephSerpis
17 - Castor
17 - Castor

Hi @gmurali I mocked up a workflow that produces the output you describe let me know what you think?

 

Transpose_08092020.JPG

AngelosPachis
16 - Nebula

Hi @gmurali

 

The attached workflow should give you what you're looking for

 

Annotation 2020-09-08 104148.png

grazitti_sapna
17 - Castor

Hi @gmurali , try this easier solution.

grazitti_sapna_0-1599559851285.png

 

Thanks.

Sapna Gupta
Danish409
7 - Meteor

Hi @gmurali

Alternatively you can use Tile,Transform & Text to column to get the desired solution.

Screen-08-09-2020_161119 (2).png

Please find the attached workflow.

 

Thanks

gmurali
6 - Meteoroid

Thanks a lot. This works perfectly. 

Labels
Top Solution Authors