View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default moving data from numerous colums into one colum

Hi,

I have to move the data from numerous columns into one colum as a list,
how can i do this?

eg
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10

to
1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10

please help?

thanks,