Copy data to new sheet - Help inserting loop

[coop_coop]

Hello,

So I have a question that I think will be very easy for a lot of you but I have data on one sheet and need the output in another sheet, copy and paste transpose. All I need to do is identify the first row in the "Original Data" sheet" and transpose paste to the "Transformed Data" sheet in Column C like you can see in the attachment. The first part (just for the first row of data) is very easy and I will paste the code I have below, but I need help writing a loop that will continue using the same logic (i.e. once one row is copy/pasted, move down to the next row and do the same thing until the end). This is my first time posting here so I apologize if I am not giving enough detail but happy to answer any questions.

Thanks a lot for the help!

Please Login or Register  to view this content.

[bsalv]

before starting write something in D1, so that that cell isn't empty

Please Login or Register  to view this content.