I have a list of data that I need to rearrange in a specific way in the next sheet.

![the sets of data](https://i.stack.imgur.com/Af1zr.jpg)

I want to make the data to automatically be inputted to the next sheet as below as the total data is actually a lot and it takes time to do this by transposing and copy pasting to the correct order.

![the intended result](https://i.stack.imgur.com/7vDWq.jpg)

Is it possible to make the data be arranged as such automatically by functions/macros?