We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Transpose -Horizontal to Vertical data

hzpetro
7 - Meteor

Hi..I am quite new to Alteryx. I have a horizontal data that need to be under vertical data and it should be group as below. Can someone guide me how to do this?

 

 

Screenshot 2023-09-16 212331_input.jpgScreenshot 2023-09-16 212356_output.jpg

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @hzpetro you will need to transpose your data then clean up your column names removing the numbers at the end then you can crosstab your data into your desired format. I mocked up and approach which showcases one way of doing this. 

 

Transpose_Crosstab_16092023.JPG

 

 

hzpetro
7 - Meteor

thanks so much for the help i will study the flow that you have provided...cheerss

Labels
Top Solution Authors