In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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