Hey Team
I hope all is well.
I am trying to get and output as per requested.

Unfortunately i am not being able to get it replicated on Alteryx, maybe because I am 100% sure doing something incorrect 
Could i please have some guidance on this?
Please see attached my Workflow as it is today.
I am also attaching the input file.
Could you please give a hand?
Thanks everybody 