Sum and delete rows if columns A match

1. Sum and delete rows if columns A match

Hello, I've searched all over the Internet looking for a solution to this problem. Any ideas or help is greatly appreciated.

I have an worksheet with over 5000 rows of data. It is set up like this:

-----A----------B----------C----------D----------E----------F----------G----------H-----
Name.....Value1.. Value2.. Value3.. Value4.. Value5.. Value6.. Value7

Here is an example from the worksheet.

A. R. Napravnik.............303 62 65 54 181 20.46% 59.74%
A. R. Napravnik...............47 13 12 7 32 27.66% 68.09%
Abel Castellano, Jr........131 37 20 21 78 28.24% 59.54%
Abel Castellano, Jr..........95 20 11 12 43 21.05% 45.26%
Abel Marian.....................2 0 1 0 1 0.00% 50.00%
Alan Garcia......................1 0 0 0 0 0.00% 0.00%
Alberto Delgado..............33 1 0 3 4 3.03% 12.12%
Alberto Delgado................5 1 0 0 1 20.00% 20.00%
Alberto Delgado..............11 0 1 1 2 0.00% 18.18%
Aldo Arboleda...................1 0 0 0 0 0.00% 0.00%
Alexis Freites...................2 0 0 0 0 0.00% 0.00%

Columns G and H calculate by formula, what I would like is to be able to identify duplicate names and combine them into one row.

A. R. Napravnik.............303 62 65 54 181 20.46% 59.74%
A. R. Napravnik...............47 13 12 7 32 27.66% 68.09%

I would like to have:
A. R. Napravnik.............350 75 77 61 213 21.42% 60.86%

Ideally they would combine in rows A-H, but that isn't a major issue. The key is to combine duplicates throughout the entire document without having to manually enter the names to combine.

Thank you.

2. Re: Sum and delete rows if columns A match

``Please Login or Register  to view this content.``

'COLUMNS TO ROWS
Here's a macro for merging rows of data to one row matching for column A.
I just ran it on that sample data and it seemed to work with no edits. Just make sure the data starts in row2.

3. Re: Sum and delete rows if columns A match

Awesome. Thank you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1