Output

[Inactive User]

Hi Everyone,

I have a input table, which i want as a desired output find below Screenshot:

can anyone help ?

[BrandonB · Accepted solution]

This should do it. Workflow attached:

[Robin_McIntosh · Accepted solution]

[gelvira · Accepted solution]

I would do it this way. Can be optimized further. 

[Inactive User]

Hi @Robin_McIntosh,@gelvira,@BrandonB,

Thanks for the solution, it worked for me .