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
Solved! Go to 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.
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".?
Config of Tile:
config of Cross tab:
O/P:
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.