Not able to get the Desired Output as attached

[8802036946]

Need to have output as desired, from the input attached.

[Shifty]

Hey @8802036946 

You could try this:

I've attached the packaged workflow that does the job.

[binuacs]

@8802036946 One way of doing this

[cjaneczko]

The cross tab tool will get you there. I had to add a record ID to preserve the sort.