Restructuring data

[D_N_L]

Hi all,

I’m trying to write some VBA which can reorganise my data but I literally have no idea where to start with this one. I’ve attached an example workbook of a before and after showing how my data is and how I need to transpose it.

Can anyone provide any pointers? I was thinking I need a loop maybe?