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:

MEMBER FIRST NAME

MEMBER LAST NAME

MEMBER #

MVP SYSTEM ENTRY DATE

ENROLL DATE

MVP POINTS

DRAWING ENTRIES

ENROLL FORM?

POINTS CORRECT?

POINTS MISSED

FINAL POINTS

DRAWING ENTRIES

SP Talon #

WP Talon #

BIKE DEAL

DEPT

EMPLOYEE

NOTES

DEALER

Gene

S

550061

3/2/2013

0

0

0

#N/A

Gene

S

550061

3/2/2013

1539

137

MC

MJ

SP

Steve

G

550087

3/2/2013

30019

1588

PA

NR

WP

Curtis

S

550128

4/24/2013

5

0

5

#N/A

Curt

S

550128

4/24/2013

358

47

MC

MJ

SP

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

 

[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!