Transpose Columns to Rows and Summarize values

Hello!

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

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

Datasets

Output

Preparation

Accepted answers

Try This

Can you attach a sample data set?

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