Hi!
I have a rather unique question. I'd like to rearrange my data in Alteryx Designer.
For example, let's say I have two people who have taken a three question survey.
Right now, my data looks like this:
Name Question Answer
Joe Favorite Holiday Christmas
Joe Favorite Color Blue
Joe Favorite Food Burgers
Jane Favorite Holiday 4th of July
Jane Favorite Color Red
Jane Favorite Food Cheese
But I'd like my data to look like this:
Name Favorite Holiday Favorite Color Favorite Food
Joe Christmas Blue Burgers
Jane 4th of July Red Cheese
How would I accomplish this?
Thank you!
Solved! Go to Solution.
Attaching a sample workflow for your case. You can accomplish the desired results using cross tab tool. Hope this is helpful.