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.