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.

Instead of:
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.

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.

Columns to Rows - Part 4

I just ran it on that sample data and it seemed to work with no edits. Just make sure the data starts in row2.