Loop, Copy and Transpose

Hi, I'm hoping someone can help me out with the following.

I have data in Col B (+- 9000 rows) and want to copy four cells (starting in "B3:B6") and transpose it in "H2".
Then find the next 4 cells in col B, copy and transpose this in "H3" and so on

I need to repeat this till the first empty cell in Col B.

Unfortunately, i'm struggling with loops and am hoping someone can help.

Thanks in advance.

How about just a worksheet function solution?

Thank you very much for your insight.

What does "Step 4" imply in this instance. Thank you

Thanks again. One last question...

If i change Offset(1) to Offset(2) then it creates an empty row btw each row that was pasted.

Please Login or Register  to view this content.

Is this just a indication of the destination to whihc it is copied, so if i change it to Offset(2) then it should only move to pasted data on row down. Which it does But it also inserts an empty row btw each pasted row.

Thanks for you time

Thanks again for your willingness to help me understand