I have multiple csv files in multiple folders which contain data from a
Agilent 6890n MSD (see attached csv data files and a version of the data that I processed in an excel)

The raw data is organised in a format where the measured analyte peaks and mass spectral library identification data are not arranged side by side. This makes manual processing of the data in excel very labor intensive
I am an including example csv files and the way I would like the data to be formatted in excel.

Is there a way to create a macro to read the csv files in the folders and organize it into a final format in an excel spreadsheet (see Final Data Layout Worksheet)

The link to download example data and excel spreadsheet is shown below.

I hope someone can help as I am flooded with a huge amount of useful data but its in a useless format.