Given a table with unique and duplicate text values in a column with number values adjacent in the following format:
A|12
B|23
C|98
A|66
D|86
E|3
B|25
A|65
.
.
.
The values are simplified for the example. They are actually longer and the ones in column one are letter and number value combinations and punctuation in cases. e.g. "/ab12345.html","/ab23456789/"
I need to add the adjacent values of text cells from the first column and end up with a separate 2nd column set of only unique numbers in Column "A" and their values in column "B" to be the SUM of all their adjacent values from the original set.
In essence like so:
A|143
B|48
C|98
D|86
E|3