How to combine values from multiple rows into a single row in Excel 2007

[mvail]

I have an Excel 2007 spreadsheet with 2250 rows and 19 columns. In these rows, I may have two rows of duplicate customer information that need to be combined. I may also have rows of customer data that are not in need of combining. A unique customer member number can be used to identify the rows that need to be combined together. I'm struggling on developing the right VBA script to combine the unique customer data into the one row (on top) and delete the row that is remaining after combining. Is anyone willing to assist? It will save me hours/days of hand combining these rows and we are in the middle of a time sensitive audit. Thank you!

Sample of our data:
[TABLE="class: grid, width: 1440"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD]MEMBER FIRST NAME
[/TD]
[TD]MEMBER LAST NAME
[/TD]
[TD]MEMBER #
[/TD]
[TD]MVP SYSTEM ENTRY DATE
[/TD]
[TD]ENROLL DATE[/TD]
[TD]MVP POINTS[/TD]
[TD]DRAWING ENTRIES[/TD]
[TD]ENROLL FORM?[/TD]
[TD]POINTS CORRECT?[/TD]
[TD]POINTS MISSED[/TD]
[TD]FINAL POINTS[/TD]
[TD]DRAWING ENTRIES[/TD]
[TD]SP Talon #[/TD]
[TD]WP Talon #[/TD]
[TD]BIKE DEAL[/TD]
[TD]DEPT
[/TD]
[TD]EMPLOYEE[/TD]
[TD]NOTES[/TD]
[TD]DEALER
[/TD]
[/TR]
[TR]
[TD]Gene[/TD]
[TD]S
[/TD]
[TD]550061[/TD]
[TD]3/2/2013[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gene[/TD]
[TD]S
[/TD]
[TD]550061[/TD]
[TD][/TD]
[TD]3/2/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1539[/TD]
[TD]137[/TD]
[TD][/TD]
[TD]MC[/TD]
[TD]MJ
[/TD]
[TD][/TD]
[TD]SP[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]G
[/TD]
[TD]550087[/TD]
[TD][/TD]
[TD]3/2/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]30019[/TD]
[TD]1588[/TD]
[TD][/TD]
[TD]PA[/TD]
[TD]NR
[/TD]
[TD][/TD]
[TD]WP[/TD]
[/TR]
[TR]
[TD]Curtis[/TD]
[TD]S
[/TD]
[TD]550128[/TD]
[TD]4/24/2013[/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]#N/A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Curt[/TD]
[TD]S
[/TD]
[TD]550128[/TD]
[TD][/TD]
[TD]4/24/2013[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]358[/TD]
[TD]47[/TD]
[TD][/TD]
[TD]MC[/TD]
[TD]MJ
[/TD]
[TD][/TD]
[TD]SP
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mvail]

I really could use some help with the VBA to make this work. I know there are a few out there, but I just cannot get the code modified correctly to make it work in my situation. Is there anyone out there that may be able to help me out today? Thanks a million!

Marcy

 

[djas56]

Marcy,

Did you ever figure out a way to merge the rows? I have the same problem and would really appreciate any help!