Help with Transposing Code

Hello all,

I have been assigned to transpose and reformat loads and loads of data. I am familiar with excel and computer programming (mostly matlab), but I have never written code for excel. I have begun the assignment using the transpose function and going line by line.

I have attached the portion of the data that I have already processed. In the first worksheet, the data is formatted as it is given to me. In the second worksheet is the format to which I must convert the data. Essentially, all the data for 1 subject must be placed in 1 row. The especially tedious part (transposing) has been highlighted in red. There are varying amounts of data that must be transposed, but there is consistently 1 blank row between subjects.

If anyone has ideas for helping me with this assignment it would be very much appreciated.