Copy paste in excell

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.