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.

Thanks a ton man... I ran the code and it appears to have worked other than that it skipped 2 rows, I am trying to figure out why it skipped them, but haven't had much time to investigate it. Thanks again rylo, I may have some questions about how the code works after I get a chance to look at it some more

Hi

did it skip them in the example file or in something else?

rylo

the skips occurred in an extended version of the same file... I would post the entire file, but I didn't record the data so I don't feel it is my place to put it on the internet... It appears to me that these skipped rows occurred due to missing data in the U column referenced in the code. Should be an easy fix

Hi

IF there is likely to be data missing from column U, then which column for the "first appearance" type rows will always be completed?

rylo