Transforming Data for import into Access 2007

[squirrely]

Hello,

I have countless .csv files in a folder which i want to import into access 2007.
The structure of all files are the same, however in a difficult format for me to rearrange and import into Access 2007 where the access table will make sense.

I have attached the .csv file

I would like the data to look like the excel spreadsheet i have attached.

Cheers,