Transposing Data

[FabianAvina]

So I have a data file that looks like this:

I need to get it into this format:

Any suggestions to do this more efficiently? 

[Qiu]

@FabianAvina 
This may be possible with Multirow and Transpose Tools.
But please upload your data for us, not the pictures.

[FabianAvina]

Here is the file.

[Qiu]

Hope this will work for you.

[FabianAvina]

Yes. Thank you so much!!