Spread one column across 3 columns

[jetheat]

I have one column full of data and I want to spread this across 3 columns.
So the 2nd cell down will now be A2 and the 3rd cell down will become A3 and the 4th cell down will now become B1.

How do I do this automatically?

Appreciate the help,

JH

 

[pgc01]

Hi

Do you mean "spread this across 3 rows.", or is the example wrong?

 

[Jacophile]

Assuming the data is in column A, enter these formulae in the indicated cells
A2 =OFFSET($A$1,(ROW()-1)*3,0)
A3 =OFFSET($A$1,(ROW()-1)*3+1,0)
A4 =OFFSET($A$1,(ROW()-1)*3+2,0)

then fill down in columns 2,3 and 4

 

[jetheat]

Thanks for that. That worked great.

JH