Using the data in the posted Access file, an Access query can generate the 3-column dataset.



As for the import of raw data, the how depends on the source and structure.