Hello Designer Community
I am new to Alteryx and hoping to get your help on what might be a fairly simple problem. I'm building my second workflow and have a problem where currently, the output to xlsx results in the following:
Question | Response |
School | Connecticut High |
Class | Apple |
Name | John Smith |
Grade | 9 |
School | Epping Junior |
Class | Orange |
Name | Terry White |
Grade | 7 |
School | Orange County |
Class | Green |
Name | Helen Jane Barnes |
Grade | 4 |
However, the desired output should be:
School | Connecticut High | Epping Junior | Orange County |
Class | Apple | Orange | Green |
Name | John Smith | Terry White | Helen Jane Barnes |
Grade | 9 | 7 | 4 |
Thank you in advance for your time and any guidance.
Solved! Go to Solution.
Hi @j_c ,
So what do you want us to help? transfrom from current output to desire output?
I think you should provide input file and we'll help you to transform to your desire output, it's better.
You can use a Tile and CrossTab tool to achieve this. The Tile tool creates sets for you desired rows but re-sorts the data in the process. You can do this manually with a multi-row formula instead if the order of the output rows are important.
The CrossTab tool then flips the data around.
Thanks David P - that worked a charm. It would be great if I could rearrange order of the output e.g. have the name as the first row. I've tried to play around with the multi-row formula but I am stuck with how to write the expression. Is there any chance you could please help me? Thank you so much!
Thanks so much for your help David!!