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