Selected Column to Row Conversion

[DomMiro]

I am hoping someone can help me. Its hard for me to explain what i am trying to do so I am posting the picture how the data is now and how i would like it to be:

Now:

How i would like it to be:

I am also attaching the sample data file. Any help would be greatly appreciated!

[PhilipMannering · Accepted solution]

I get a few more records than your desired output, but hopefully this helps...

[DomMiro]

Thank you very much! Works great!