How can I get data by grouping one row and sum related to grouping in 2nd column

How can we have Something like this:

basically this is sum in column B

This can be done using Pivot table

1 Like

image
image

1 Like