Hello all, I'm glad to have found such a great place to learn about excel. I'm the kind of guy who learns from seeing the answer and working backwards. That being said here is my issue:
I one Sheet 1 I have the following:
Columns F2:R2 have values in them. I would like to copy those, transpose them to E2.
THEN SKIP the 13 rows and do the same thing to rows F16:R16, transpose to E17.
This needs to loop until it hits a blank cell. The whole sheet is about 3k rows with the blanks already waiting for the transpose.
I can't get it figured out.
Thanks in advance and I can't wait to see how this works out!
I one Sheet 1 I have the following:
Columns F2:R2 have values in them. I would like to copy those, transpose them to E2.
THEN SKIP the 13 rows and do the same thing to rows F16:R16, transpose to E17.
This needs to loop until it hits a blank cell. The whole sheet is about 3k rows with the blanks already waiting for the transpose.
I can't get it figured out.
Thanks in advance and I can't wait to see how this works out!