Transpose data from one format in xls to another

I have data in one format in xls and in order to input it into a database I need the data in a different format. The xls attached has 2 sheets the first one you need to work on. The second illustrates the results

The current data format is in green. The desired format is in yellow. This video explains how to transpose the date. Please get in touch if this is not clear. Immediate turnaround is preferred. https://www.loom.com/share/bcfa32ae578f41138d35403fd29010fe?sid=1ea46400-cd3b-4f08-a608-7d7a6461e8a1

YOu did this for me previuously and the developer wanted it a different way so I am back.

Kind regards

Alex