I am having data in the shown format:
The output required is in the below format:
Here, the Category column unique values are added as the column names and then for every Item No. sum of Contribution is done accordingly. Like RC100 has RM-DU Sum = 35 +50 = 85 and so on and at last total column is added which does the row wise sum.
The excel file is attached here Convert and Sum.xlsx (9.2 KB)