Table Transform

J

James

I have a table which is 6 rows by 4 columns & I would like to transform
this into 24 rows by 1 column. That is, copy the contents of column 2,
3 & 4 to the bottom of column 1. How can I do this? Thanks
 
J

James

I meant programmatically since the transpose function does not work in
this case.
 
D

David Biddulph

If your table is in A1:D6, then in A7 put the formula
=OFFSET(A$1,MOD((ROW()-1),6),INT((ROW()-1)/6))
and copy down to A24.
 
Top