Maybe i have not made this clear enough - my apologies.

Each number/letter is in its own cell

So A1=1, A2=5 etc.

I want to take A1:D1, E1:H1 and put in a new place below each other. So 1 2 3 4 5 6 7 8 becomes:
1 2 3 4
5 6 7 8

I can easily do the first by hand but i have a lot of rows and columns.