Jump to content

Consolidate and Add Values


Audrey W.
 Share

Recommended Posts

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
Link to comment
Share on other sites

  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...