Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transpose
Hello,
Can anyone help me? I have a column of numbers as follows: 1 2 3 Using copy/paste special transpose i can put them into a row but only as follows: 1,2,3 Does anyone know a quick way to put them in this order:3,2,1 Cheers Joe |
#2
|
|||
|
|||
Joe
Sort them first in the column? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Joe the Toe" <Joe the wrote in message ... Hello, Can anyone help me? I have a column of numbers as follows: 1 2 3 Using copy/paste special transpose i can put them into a row but only as follows: 1,2,3 Does anyone know a quick way to put them in this order:3,2,1 Cheers Joe |
#3
|
|||
|
|||
Hi
try the following formula: =OFFSET('sheet1'!$A$3,COLUMN(A:A)-1,0) and copy this to the right "Joe the Toe" wrote: Hello, Can anyone help me? I have a column of numbers as follows: 1 2 3 Using copy/paste special transpose i can put them into a row but only as follows: 1,2,3 Does anyone know a quick way to put them in this order:3,2,1 Cheers Joe |
#4
|
|||
|
|||
Hi,
Firstly, sort the numbers in the way(order) you want them to appearafter tranpose. Thank you, K.S.Warrier "Joe the Toe" wrote: Hello, Can anyone help me? I have a column of numbers as follows: 1 2 3 Using copy/paste special transpose i can put them into a row but only as follows: 1,2,3 Does anyone know a quick way to put them in this order:3,2,1 Cheers Joe |
#5
|
|||
|
|||
I'm assuming the 1,2,3 etc are not representative of your data and merely
indicate the existence of a number, else you would just sort first and then transpose. Put a helper column next to your numbers and put 1 in the firts, 2 in the second and then select both and fill down, so you get something like:- 738 1 585 2 626 3 368 4 379 5 799 6 123 7 787 8 835 9 741 10 151 11 479 12 877 13 813 14 443 15 966 16 Now just select the entire set of data and do a Sort / Descending based on the helper column, and then transpose. You can also Transpose first and then just do this on a horizontal basis sorting right to left. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Joe the Toe" <Joe the wrote in message ... Hello, Can anyone help me? I have a column of numbers as follows: 1 2 3 Using copy/paste special transpose i can put them into a row but only as follows: 1,2,3 Does anyone know a quick way to put them in this order:3,2,1 Cheers Joe --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.789 / Virus Database: 534 - Release Date: 07/11/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose a column into many rows | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
Transpose Problem | Excel Discussion (Misc queries) | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
TRANSPOSE() | Excel Worksheet Functions |