View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Narendra Boga[_2_] Narendra Boga[_2_] is offline
external usenet poster
 
Posts: 38
Default transpose multiple rows at once

hii all...

a small doubt about Transpose in Edit menu.

Here Iam spending much time to transpose each row into one column. There is
any option to reduce my time on this issue?
The data is like this.......

A B C
1 12 13 14
2 15 16 17
3 18 19 20

I wanna arrage the values spread in A, B, C..into one A coulmn. I use
pastespecial--transpose. But it takes much time to arrange all rows. Is
there any other option to transpose all the data into one column???
I need the data like this...

A
1 12
2 13
3 14
4 15
5 16
6 17
7 18
8 19
9 20


Thanks,
Narendra