I have two columns of data:

Name Value
A 1
A 1
B 1
C 1
C 1
C 1

I would like to sum or count each value in the Name column so that the
results would be:

A 2
B 1
C 3

There could be instances were the rows get sorted so that Names may not also
appear together or in the same order and there could be additional rows added.

Any suggestions would be appreciated.