Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRANSPOSE 'group' of columns to rows | Excel Discussion (Misc queries) | |||
Can you transpose 1 column into multiple rows creating a table | Excel Discussion (Misc queries) | |||
how do i transpose rows to clumns? | Excel Worksheet Functions | |||
transpose a column into many rows | Excel Discussion (Misc queries) | |||
how do I transpose columns and rows | Excel Discussion (Misc queries) |