LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRANSPOSE 'group' of columns to rows tom Excel Discussion (Misc queries) 1 December 14th 06 06:19 AM
Can you transpose 1 column into multiple rows creating a table Richard Excel Discussion (Misc queries) 6 November 2nd 06 09:46 PM
how do i transpose rows to clumns? berkin benli Excel Worksheet Functions 1 April 29th 05 04:01 PM
transpose a column into many rows GMed Excel Discussion (Misc queries) 1 January 21st 05 07:15 PM
how do I transpose columns and rows jnix Excel Discussion (Misc queries) 10 December 22nd 04 01:44 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"