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.

DavidP

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

crosstab with tile.yxmd