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!
Solved! Go to Solution.
Thank you @gawa ! This one completely slipped from my mind.