View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
alansi alansi is offline
external usenet poster
 
Posts: 1
Default how to marge many columns to single column

Dear friends i have many paralled columns that i want to converte it to
single column by making each column follow the other. for example

A E I
B F J
C G K
D H L

i want to change it to single column without copy and past because i have
too many columns.
as follow

A
B
C
D
E
F
G
H
I
J
K
L

any idea how to make it in excle

thanks