I can create a simple formula that will parse your data into this format of output. It is capable of handling any amount of information, and is extremely easy to use (just copy and paste the formula once, then drag it out to fill out all of the rows you need).
If you could please PM me with a sample of your input data, I can create a test document to prove my claim.