Thread: Table Transform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 3
Default 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