Excel transpose functionality

I have dataset in excel in below arrangement.

enter image description here

And I would like to change it to below manner

enter image description here

What would be the best way to perform the task? The actual data file is too big and simply performing Copy-Paste(in Transpose) is taking too much time.

Any help would be really appreciable!