Cross Tab / Summarize tool to summarize values in multiple columns

[HKR_4410]

I have data like below:

and would like an output like below.

[JosephSerpis · Accepted solution]

Hi @HKR_4410 I mocked up a workflow that produces the output you describe let me know what you think?

[grazitti_sapna]

Hi @HKR_4410 ,

This is my take on the problem, I hope it helps.

[HKR_4410]

Thanks @JosephSerpis  and @grazitti_sapna  for your prompt reply. Both the solutions worked perfectly...