Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

Originally Posted by eli_

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!

Attached Files

sample donor list.zip (6.3 KB, 31 views)

Last edited by Spencer101 : August 14th 12 at 08:11 PM

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dollar amounts aren't merging from Excel into a Word document...	Sharon	Excel Discussion (Misc queries)	3	February 19th 09 02:41 PM
Merging duplicate lines in a Database	Darren	Excel Discussion (Misc queries)	1	November 27th 08 07:12 PM
Combining and merging duplicate data.	Darren	Excel Discussion (Misc queries)	2	November 27th 08 02:38 PM
Look up duplicate amounts with unique batch numbers	JHL	Excel Worksheet Functions	3	May 6th 08 11:14 PM
Merging duplicate rows	mattis2k[_3_]	Excel Programming	4	November 15th 03 07:25 PM

All times are GMT +1. The time now is 03:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us