hi i see lots of posts about merging but could find none that really address my problem.
im trying to organize a 10k+ name donor data base list that has names of donors, with how much they have donated, every year in yearly increments starting from 2006..... the problem is that excel displays the list as follows
(see attachment below)

what i need it to display is
bob $500 600 800
jack 100 400 300

none of the merging commands that i have tried helped
if anybody can help that would be much appreciated thanx so much!!

Hi, perhaps with some anonymised sample data in an Excel file it would be easier to help you out with this...


S.

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!

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

You did really!

What solution are looking for: Functions or VBA?

Bruno