I have data in these format is there any function or formula is available in excel to arrange data the way I want?
1.png

I want to arrange data in below format, I used transpose but it didn't work the way I want.
2.png

example.xlsx