Excel Need help with identical data merging in Excel.

[Tolu]

I am trying to shrink an Excel worksheet that has the same alphabetical data in various columns, but different numerical data in each corresponding column, e.g. I would like to shrink all of Jon Doe's entries into one row, such that the '# of events' column has a total of all his events.

Please see the table on the Word attachment below.

Is there a way I can make this happen in excel, or is there any other application that can? Thanks!

 

[Jason.369]

Add up the totals and then get rid of the remaining entries for the name

If that isn't what you're asking then could you be more clear please?

 

[Tolu]

Thanks Jason.. I wish it was that easy, but the sample I attached was just a small one I created to give an idea of what I was trying to do.

The actual data table has about 5,000 rows, which I believe I can shrink to like 2,000 rows. I sure don't wanna sit there adding the totals.. lol. I'll have to get up and go home sometime, you know.. lol.

Hey.. thanks! and I hope that you or someone will have an answer for me soon.

 

[Jason.369]

See if you get any joy out of either of these:
* - Clicky.
* - Clicky


...otherwise, I'm sorry, I do not know a shortcut for doing what you wish to do.

 

[Tolu]

Jason.. that was really helpful! It didn't completely solve this problem, but it gave me answers to other Excel issues I had previously.. Thanks!