Data Consolidation

Hi Team
I have a set of data in Sheet 1 ( Data vs value ) . I want to consolidate the value according to its data in the same sheet. This can be done in Pivot but I am looking for an option / formula to get the result in the same sheet , instead of getting it through Pivot from other sheet .

Input E.g :
Data Value
A 1
B 1
A 2
B 3
C 1
C 1
A 1

Result looking for ( in the same sheet somewhere are the right side ) :

A 4
B 4
C 2

Pls help if you have any option

Regards
Karthikeyan