Moving data from Rows to column keeping the same grouping

Question

Hi

I have my input data in the below format:

BiologyAlpha CBiologyAlpha FBiologyAlpha IBiologyAlpha LBiologyAlpha OChemistryAlpha BChemistryAlpha EChemistryAlpha HChemistryAlpha KChemistryAlpha NPhysicsAlpha APhysicsAlpha DPhysicsAlpha GPhysicsAlpha JPhysicsAlpha 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:

BiologyChemistryPhysicsAlpha CAlpha BAlpha AAlpha FAlpha EAlpha DAlpha IAlpha HAlpha GAlpha LAlpha KAlpha JAlpha OAlpha NAlpha M

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

Thanks

Book1.xlsx

grazitti_sapna · Accepted Answer

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

nbandla · Accepted Answer

Config of Tile:

config of Cross tab:

O/P:

Jitendeep_Singh · Accepted Answer

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.