Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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