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...
@Surajnair take at the workflow attached that should help. Let me know how you get on
Thank you so much!
Can you please tell me in detail about the formula you used. how is number getting incremented
