Cut/Copy/paste Excell sheet

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.