Text-to-columns-like (probably) VBA script

Greetings all,

I have a raw data sheet that looks like this:

Screen Shot 2016-05-19 at 10.28.49 .png

I want to parse out the data in A, which is separated by comma/space to new rows, while duplicating information in other columns, like this:

Screen Shot 2016-05-19 at 10.32.41 .png

I'm fairly adept at non-VBA functionality, but beyond importing the data into Access (which I also don't know how to do), this is bewildering on how to accomplish.

I'm grateful to any help. Cheers!