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!
Bookmarks