How to structure data horizontally instead of vertically

[j_c]

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.

[huynv96]

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.

[DavidP]

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.

[j_c]

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!

[DavidP · Accepted solution]

On 2nd thought, perhaps something like this is easier than trying to figure it out with multi-row

[j_c]

Thanks so much for your help David!!