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