The job is pretty easy,
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:
-Import the XML file in Excel (50 articles or less each file)
-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 Project Owner,
I am interested in this project. I have understood the requirement and able to complete this project error free as your requirement.
I can start this project today and can complete within 24 hours.
Wish to get response from you.
Thanks
Hi, I think you have also creates another project for the same task. I have already bidded for the other project.
I am currently available and will try to finish the task quickly within your timeline with quality work.