Copy 7 columns on 1 row and Paste transpose

[bluemanuk1]

Hi,

I am looking to be able to do the following.

1) Go to cell, copy 8 cells to the right.
2) Paste special transpose
3) Got down 10 rows from top of transpose result and repeat action, until no more data.

Hope someone can help.

Kind Regards,

Heath