Excel Need help with identical data merging in Excel.

Joined
Mar 20, 2008
Messages
3
Reaction score
0
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!
 

Attachments

Last edited:
Add up the totals and then get rid of the remaining entries for the name :confused:

If that isn't what you're asking then could you be more clear please? :confused:
 
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.. that was really helpful! It didn't completely solve this problem, but it gave me answers to other Excel issues I had previously.. Thanks!
 
Back
Top