if you want to understand the job look at this sample
[login to view URL]
it's how it look before and after.
For each article you need For each ID number get all the information in one raw as shown.
Step by step:
-delete the extra columns and keep only Result ID, Atl, Subj, Jtl, year, Au(thor), affiliation, url, ab
-Copy the Subj for each article in a single cell (See final)
-Put all the authors (Au) and respective Affil (when available) for each article in the same row and different column as shown in the FINAL sheet
The Goal is simply to have all the information for each article in the same Raw.
Dear Employer,
I am new to freelancer job, but I have experience working with excell databases. I am now one of the International NGO project officer, where I have numerous data entry jobs daily. I am very detail oriented, accurate and fast worker.
Thank you in advance for giving chance to do the first project on freelancer site.
Sincerely Yours,
Sopho/Sophia
Dear Employer we a team of 10 efficient members to complete your project in a single day. Also rate will be negotiable as what you want. Thank you and have a nice day.
Hi, After reading the project description, i am confident that i can do this job. I hope you will consider me for this job and i can start immediately. Thanks
I agree i don't have any passed tests from Freelancer but I'm currently in 3rd year Electronics Engineering. This Job is a piece of cake for me! You can trust me. You won't regret it.