Moving data from Rows to column keeping the same grouping

[Aryan1182114]

Hi

I have my input data in the below format:

Biology	Alpha C
Biology	Alpha F
Biology	Alpha I
Biology	Alpha L
Biology	Alpha O
Chemistry	Alpha B
Chemistry	Alpha E
Chemistry	Alpha H
Chemistry	Alpha K
Chemistry	Alpha N
Physics	Alpha A
Physics	Alpha D
Physics	Alpha G
Physics	Alpha J
Physics	Alpha M

I want my column A to be transposed and reflect as column headers and reflect the list of students from column B in the below format:

Biology	Chemistry	Physics
Alpha C	Alpha B	Alpha A
Alpha F	Alpha E	Alpha D
Alpha I	Alpha H	Alpha G
Alpha L	Alpha K	Alpha J
Alpha O	Alpha N	Alpha M

You can also refer to the attached excel for the input and output data.

Thanks

[grazitti_sapna · Accepted solution]

Hi @Aryan1182114 , try this I hope it works and if this is the solution to your problem please mark this post as a solution.

[Aryan1182114]

@grazitti_sapna

Thanks for the solution; due to different Alteryx versions i am unable to open the file. Would it be possible to share the configuration snip for "Tile" and "Corss Tab".?

[nbandla · Accepted solution]

Config of Tile:

config of Cross tab:

O/P:

[Jitendeep_Singh · Accepted solution]

Hi @Aryan1182114, you can simply extract the package and open the .yxmd file in notepad and change the version to the one you are using that will make the workflow work.

Thanks.

[sgwong]

need assist on how to change the data to the attach output format