Table Transform
 

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

Table Transform
 

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

James wrote:
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

Table Transform
 

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.
--
David Biddulph

"James" wrote in message
ps.com...
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

Table Transform
 

It works! thanks


David Biddulph wrote:
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.
--
David Biddulph

"James" wrote in message
ps.com...
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