Transpose Columns to Rows and Summarize values

[mercurial_maverick]

Hello!

I've a workflow that results in the below output.

I want the above output to be transformed to the below view. 

[tsturge]

Can you attach a sample data set?

[mercurial_maverick]

Hello @tsturge 

Please find attached file sample dataset in Input tab and desired output in Output tab

[tsturge · Accepted solution]

Try This

[mercurial_maverick]

@tsturge This worked! Thank you sir 😊