Transpose cells in groups of 4

Dear Excelforum

I have a dataset that is about 100 rows and also about 100 columns wide. From every row i want to take the cells in groups of 4 and align below each other instead of next to each other.

The information is currently like this:

12345678
ABCDEFGH

I want it to be like this:

1234
5678
ABCD
EFGH

----

So i want to finish one row at a time.

The solution is probably simple but i can't seem to make anything work.

Help is much appreciated - thank you in advance

/Hremehre

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.

Please find attached Excel sheet.


Regards,
Suhas