Excel Job, re-arranging and combining data

I have two things i need completed.

I have about 500 records in excel in two files.

One file contains account information(Name, Address, City, State, Zip, Phone, Fax ect..)

The other file contains Notes for accounts(Notes, Name)

First i need you to grab file number 2(notes) and combine all notes for the specific name.

If you look at the example excel sheet you will see that A1 and B1 is how i need it to be and A2,A3,A4,B2,B3,B4 is how they will look like. In short It will have multiple notes for one name, i need you to combine the notes for each person separated by a Line Feed in A1 and keep the Name in B2.

Once that is done for the Notes file, I then need you to add the notes to the account name in the account file. Lets say there are notes for Brian Campbell, not you add the notes from the notes file to the account Brian Campbell from the account file.

If you have any questions please let me know. I need this done today. It should only take a few hours to complete and if you are good then it should take less then an hour.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: should i take the job, one hour job, me excel, job see, job questions, job complete, i need data entry done today, complete job, any job done, A3, a1, today data, line sheet, job today, hour job, excel job, combine excel, city 500, B3, b2

Tietoa työnantajasta:
( 60 arvostelua ) laval, Canada

Projektin tunnus: #547800

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi, please view my PM for details, thanks.

$30 USD 1 päivässä
(107 arvostelua)

Hi, Ready to start work now thanks sunny

$33 USD 1 päivässä
(26 arvostelua)

Sir give me a chance i want to start it now.

$30 USD 2 päivässä
(6 arvostelua)

Hi Ready to do this project.

$30 USD 1 päivässä
(0 arvostelua)

need work as soon as possible

$50 USD 2 päivässä
(0 arvostelua)