Windows 7 - merging duplicate donors and donation amounts from different years

Asked By eli_ on 13-Aug-12 06:39 PM
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!!


+-------------------------------------------------------------------+
|Filename: donor list sample.pdf                                    |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=532|
+-------------------------------------------------------------------+



--
eli_




Spencer101 replied to eli_ on 14-Aug-12 01:38 AM
eli_;1604588 Wrote:

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


S.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Spencer101
eli_ replied to Spencer101 on 14-Aug-12 01:44 AM
sure i attached a pdf ..thnx so much


+-------------------------------------------------------------------+
|Filename: donor list sample.pdf                                    |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=533|
+-------------------------------------------------------------------+



--
eli_
Bruno Campanini replied to eli_ on 14-Aug-12 03:16 AM
eli_ explained :

You did really!

What solution are looking for: Functions or VBA?

Bruno