Transpose transformation

[Surajnair]

I have attached input file and desired output how i wanted.

Kindly please help me.

Note - NEW_SRN column indicated how many times same number is been repeated based on that prefix is added _1, _2 etc... 

[aatalai · Accepted solution]

@Surajnair take at the workflow attached that should help. Let me know how you get on

[Surajnair]

Thank you so much!

Can you please tell me in detail about the formula you used. how is number getting incremented