Merging Rows with same Value

[pruthvi]

Hello All

Please help me in transforming the following data set. I have tried many ways in getting the result, I can concatenate data but unable to add it to new lines. Any help will be much appreciated.

Thank you

PJ

[DiganP · Accepted solution]

@pruthvi Attached is the workflow that creates a similar table. It looks something like below. 

[pruthvi]

@DiganP . Thanks for the solution. That helped me to complete my workflow.