Transpose - repeat until change

[jmh2008]

I have an excel spreadsheet with member names and a history of all they share purchases. The row Labels are:

Last name | First Name | Purchase 1 | Purchase 2 | Purchase 3| Purchase Date 1 | Purchase date 2 | Purchase date 3

Purchases equal the Amount, which corresponds to the Date, ie

Purchase 1 = Purchase Date 1
Purchase 2 - Purchase Date 2,
etc

I want to have the following so I can import to Access: (Not all members purchase the same amount)

Last name | First name | Purchase Dates | Amount
Joe Brown may 1, 2011 10
Joe Brown Oct 2,, 2010 10
Joe Brown Feb 11, 2007 10
Mary Smith July 1, 2000 10
Frank Jones Nov 1, 2000 10
Frank Jones March 4, 1999 10

Thanks!!

 

[jmh2008]

I realize today as I was working with my database, that I didn't tell you that your code worked great!!!! Thanks so very much.

Juanita

 

[Peter_SSs]

I realize today as I was working with my database, that I didn't tell you that your code worked great!!!! Thanks so very much.

Juanita

Thanks for the feedback - it does help encourage us to help with any future questions you may have.