[MBAtarga]

My solution involved use of vlookup. I sent the revised file back to him for him to look at - it was only a partial solution - I didn't complete the spreadsheet because the data was not consistent in terms of labels between the files. He basically needs a table of raw data - where each new set of measurements that is added as another column on the right, converted to be rows of data under columns on another spreadsheet.