How to group pairs of values?

Question

excel

Hello! Help, please, to structure the data in Excel!
I have paired data in 2 columns on one sheet:

SPY 2
T 20
SPY 10
SPY 10
T 20
ITW 10
CSCO 10
SPY 20

I want to group and count this data on another sheet, i.e. to have entries like this:

T 30
SPY 40
ITW 10
CSCO 10

Please tell me how to do it?

Answer 1

It is not clear from the examples. In the example, we consider T = 20+20 = 40, SPY=2+10+10+20=42, and for some reason you have T=30, SPY=40.
If we assume that you still want to get totals for each unique value of column A, then you need to use the data consolidation tool .
Here are many links, including a video, on how to use this mechanism.
https://www.google.com/search?q=excel%20%D0%BA%D0%...

Answer 2

Make a pivot table