merging duplicate donors from different years

**eli_** · 08-12-2012, 04:19 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 (i am sorry about the space but its the only way the chart will show in the forum for some reason see attachment for better view )

name 2006

2007

2008

bob $500
bob

600

bob

800

jack 100
jack

400

jack

300

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!!

**FDibbins** · 08-12-2012, 05:42 PM

im sure some1 will come up with a better way, but start with this...

make sure that your data is sorted by name, then in column H, use this formula..=IF(a15=a14,"",SUMIFS(a15:a24,$a$15:$a$24,a15)). repeat this for each year (like i said, im sure some1 will have a better way to do this part lol)

**eli_** · 08-12-2012, 08:20 PM

thnx for answering ...just wanted to clarify i should click the entire h column and then type the "=IF(a15=a14,"",SUMIFS(a15:a24,$a$15:$a$24,a15))" formula??