Convert columns to categories

Hi all! can anyone please help me with this. I want to convert the data in first image to data in second image.
image
image

Thank you!

Hi @Anoshpananda, this looks like a job for the unpivot node as your data is currently in tabulated form and you want it converted to row-based form. I’m not at my pc right now though to provide an example but I suggest you play with unpivot and if still no joy (or if it turns out I’m wrong!) then somebody else or I will assist…

4 Likes

Unpivoting worked :grinning: Thank you :slightly_smiling_face:

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.