How to Transpose fields?

[vnorman]

I am having issues with preparing my data set. Specifically I am not sure if I am using the correct tool and/or if there is a better tool that would be more useful in my situation.

I am trying to do the following:

1. My input is

Survey 1	Q1	Q1 Rating	Q2	Q2 Rating
Survey 2	Q1	Q1 Rating	Q2	Q2 Rating
Survey 3	Q1	Q1 Rating	Q2	Q3 Rating

2. I would like the following output:

Survey 1	Q1	Q1 Rating
Survey 1	Q2	Q2 Rating
Survey 2	Q1	Q1 Rating
Survey 2	Q2	Q2 Rating
Survey 3	Q1	Q1 Rating
Survey 3	Q2	Q2 Rating

I tried using both Cross Tabs and Transpose Tools, but I have not had any luck with configuration. Nothing is giving me the result. I was thinking if there is a join tool that would help me, but most of them are for joining data from two sources, while this is coming from one source. 

I am fairly new to Alteryx and any insight would be helpful. Thank you!

[gawa · Accepted solution]

hi @vnorman 

If you want to make it simpler, you can try Arrange tool like this.

[vnorman]

Thank you @gawa ! This one completely slipped from my mind.