MS Excel Data Export and Merging

I have 2 excel files that contain data which I need analyzed and merged into a third file. The 1st file contains a list of individual people who have made donations. I would need you to find the top 50 based on largest ever donations (not hard, already done with filter) and then find those same names on file #2. File #2 contains multiple entries for each individual. I need those multiple entries compiled into one entry/row.

Example: In file #1, one of the top 50 donors is John Smith with a largest gift of $5,000. In file #2 there are 5 entries for the same John Smith showing ALL donations, including the $5,000 donation. I would need all of his donations compiled into one row of data, but excluding all duplicate information such as Name, Addres, Phone, ID number, etc.

Final row would consist of generic data (ID, Name, Address, Phone, etc) as well as gift #1 amount, date, etc followed by gift #2 amount, date, etc, gift #3, amount, date, etc. and so on.

This is something very simple that should be able to be done with VBE or a macro. I'm stuck on a Mac version of Office that does not have either of these abilities.

Evner: Databehandling

Se mere: top data, processing of data, largest number, generic excel, duplicate data entry, data entry macro, be smith, final data, smith, office macro, ms-excel, ms excel, macro excel, macro + excel, excel for mac, excel duplicate, excel data processing, excel based, excel -data, excel contains, multiple excel, excel filter list, excel macro row, excel address phone list, processing export

Om arbejdsgiveren:
( 2 bedømmelser ) Schaumburg, United States

Projekt ID: #995817

Tildelt til:


I can start work immediately. Kindly check PMB. Thanks

$30 USD på 1 dag
(31 bedømmelser)

7 freelancere byder i gennemsnit $44 på dette job


Please refer to your PMB. Thank You.

$50 USD in 0 dage
(26 bedømmelser)

Hi. Please check PMB for more details. Thank

$50 USD på 1 dag
(42 bedømmelser)

I can help you with this and I can start right now.

$30 USD in 0 dage
(1 bedømmelse)

Sir, Plz see your pmb for more detail.

$80 USD in 5 dage
(0 bedømmelser)

ready to start right now.

$30 USD in 0 dage
(0 bedømmelser)

I am very interested on the project. Rest assured you'll get 100% accuracy on it. Thank you

$40 USD in 7 dage
(0 bedømmelser)