Need a Help in Building the Workflow for sample input data

[amipanda]

Hi Team ,

Need a small help for the below asks. I have attached the input data screenshots and output

(how i want).

input data:

output data:

If anyone helps me in this would be highly appreciated.

Thank you.

[rzdodson]

@amipanda try this

[Raj]

@amipanda please share sample input Excel file.