Loop-copy cell values from a row, and then copy them into a column

Hello friends!

I was wondering if anyone knew how to write a macro that would do the following (see attached sheet):
1. select the first four cells from row 2
2. copy their values
3. paste these values into row 6
4. select next four cells from row 2
5. copy them as well
6. paste them into row 7 (aligned exactly below the values from step 3)
7. select next four cells from row 2, etc.
...
loop this until all the values from row 2 have been copied...

If you look at the attached file it might be more obvious what I mean.
Thanks a lot for any help - I'm assuming this is not difficult to do for someone who knows how to script macros, but for me it's pure alchemy I've been trying to figure this out for an hour, but to no avail...
Attachment: Book1.xlsx

Please see attached file i've done it with a simple formula, as you enter more information pull the formula further down

Let me know if it helped

Thank you

Amazing! This is exactly what I needed - thanks so much!

Could you tell me how the code works (decompose it), just so I can modify and tweak it if need come?

Try this...

Please Login or Register  to view this content.

Try this...

Please Login or Register  to view this content.

Edit: too late as usual.

Cheers, Alpha! Thanks for the second method - always good to have several ways of doing things.