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!

Sample Data.xlsx

philipmannering

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

Restructure table.yxzp