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.