TRANSPOSE-type question

I have a spreadsheet with 1000 rows that look like this:

LNAME FNAME YEAR DONATION

Adams John 1995 100
Adams John 1996 150
Smith Bob 1995 100
Smith Bob 1997 175
Smith Bob 1998 150

I want to transform the spreadsheet to this, with only one line per donor:

LNAME FNAME YEAR DONATION YEAR DONATION YEAR  DONATION
Adams John 1995 100 1996 150
Smith Bob 1995 100 1997 175 1998 150

The TRANSPOSE function doesn’t work because it puts years and donations
on two different lines. The number of donations per person varies. 
Is there a way to do this with formulas, or arrays? Or is VBA the only choice?

Thanks. 

By: Irv Cantor

Leave a Reply

Your email address will not be published. Required fields are marked *