sure i attached a pdf ..thnx so much

Could you post an actual .xls or .xlxs file? You'll have to add it to a zip file before posting as this forum won't allow Excel files unless added to a .zip file.

Include a bit of and explanation of how you need it to get from one format (i.e. a list of data) to the new format (i.e. the table in your .pdf) and you'll get a much quicker answer.

S.

sure....the format that im trying to get is to merge all the donations from one name to a single row (as u see now for every year that a donation is given it is recorded on another row)

If this is what you mean, then this is one way of doing it.

But I'd have thought a simple pivot table would have been far easier!

like that but the donations per year is important ...i already have a total list..is there a way to keep the single row per name with the different amounts donated over the different years?

Like this?

But again, a pivot table would probably be even easier.

Do you want something like this:

2006-2007 2007-2008 2008-2009 2009-2010 2010-2011 2011-2012
bob 1000 1000
jack 500 1000 500 500 600

???


Again my first question:
are you looking for a solution with formulas or with code?

Bruno

Bruno Campanini formulated the question :
Do you want something like this:

2006-2007 2007-2008 2008-2009 2009-2010 2010-2011
2011-2012 bob
1000 1000 jack 500 1000
500 500 600

???


Again my first question:
are you looking for a solution with formulas or with code?

Bruno

Sorry, contents unreadable!

bob 1000 1000
jack 500 1000 500 500 600

Bruno

eli_ explained :
sure i attached a pdf ..thnx so much

You did really!

What solution are looking for: Functions or VBA?

Bruno