How to create 3 columns from 1

[daytrader1]

Hello all,

I have one column in excel starting at Column A, here is what is in there:

2
3
4
3
2
3
4
32
2
3
3
3
3
3
3
3
4
4
5
55555

So on and so forth...

I want to take that column A and take the 1st 3 #'s, in this case above, 2-3-4 and put them in the corresponding B-C-D columns and keep going....

So as an example, using the above numbers. Row 1B would be 2, 1C 3, 1D 4, then we keep going (seperated by every 3), 2 B would be 3, 2C 2, 2D 3, etc, etc,

I want to keep seperating my Column A every 3 and put it into B-C-D

234
323
4-32-2
333
ETC ETC ETC....

I hope someone can help me out!!

[teylyn]

With your data starting in A1, put this formula in B1

=INDEX($A:$A,ROW()*3-(COLUMN($D$1)-COLUMN()))

copy across to column D and then down.