Transpose -Horizontal to Vertical data

[hzpetro]

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?

[JosephSerpis · Accepted solution]

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. 

[hzpetro]

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