Copying periodic values in a column into subsequent rows

[wadings]

Can some body help?
How can i copy a set of values to different cells. I have these numbers that keep occurring periodically in a column. And I want to copy each set of values (4 of them each) to a new column. E.g. So I have in one column these values
A
B
C
D


E
F
G
H


I
J
K
L

they are about 100 of such set of values. And i want to copy them into rows so that they look like this.


A E I
B F J
C G K
D H L

Is there any function that can do this so that i do not have to copy each set of values every time?
I tried using a macro that i recorded, but I got an [COLOR=blue !important][FONT=inherit !important][COLOR=blue !important][FONT=inherit !important]error[/FONT][/FONT][/COLOR][/COLOR] saying macro too large.
Any hints?

 

[Yahya]

see this link may be it will help
http://www.cpearson.com/excel/ColumnToTable.aspx