I am trying to consolidate rows that have some redundant rows Account (VARCHAR) and at the same time add Worth (INT) values in corresponding rows. My end result I want is to have one row per Account with the amounts for all worth combined together. If anyone has any direction that would be much appreciated!!!
Account
Name
Worth
ABD
Bob's
1.25
SDG
Susan's
22.5
DHB
Bill's
15.26
DHB
Bill's Shoes
500
DHB
Gerald
15.2
GTS
Marge
45.6
GGG
Homer
45.68
GGG
Homer
2
After:
Account
Name
Worth
ABD
Bob's
1.25
SDG
Susan's
22.5
DHB
Bill's
530.46
GTS
Marge
45.6
GGG
Homer
47.68