Home |
Search |
Today's Posts |
#1
|
|||
|
|||
transposing values top to bottom
I know how to use the paste special transpose to move values, but need help
on this. let's say I have these values in column A, starting at A1. Alpha Beta Gamma Delta I want to re-arrange these values such that they go from Delta to Alpha in a column, Delta Gamma Beta Alpha Paste Special Transpose won't do this. Any ideas? Ted |
#2
|
|||
|
|||
You could use a "helper" column where you number the adjacent cells 1 to 4.
Then, simply select both columns, and sort on the helper, descending. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Ted Metro" wrote in message ... I know how to use the paste special transpose to move values, but need help on this. let's say I have these values in column A, starting at A1. Alpha Beta Gamma Delta I want to re-arrange these values such that they go from Delta to Alpha in a column, Delta Gamma Beta Alpha Paste Special Transpose won't do this. Any ideas? Ted |
#3
|
|||
|
|||
Perhaps a formula would help
if your range is from A1:A4 and you need the values to appear say from B1:E1 then on B1 typr this and copy across thru E1 =OFFSET($A$4,2-COLUMN(),0) "Ted Metro" wrote in message ... I know how to use the paste special transpose to move values, but need help on this. let's say I have these values in column A, starting at A1. Alpha Beta Gamma Delta I want to re-arrange these values such that they go from Delta to Alpha in a column, Delta Gamma Beta Alpha Paste Special Transpose won't do this. Any ideas? Ted |
#4
|
|||
|
|||
Ted,
You can assign sequential numbers in an adjacent column and then sort the numbers in descending order. http://HelpExcel.com "Ted Metro" wrote: I know how to use the paste special transpose to move values, but need help on this. let's say I have these values in column A, starting at A1. Alpha Beta Gamma Delta I want to re-arrange these values such that they go from Delta to Alpha in a column, Delta Gamma Beta Alpha Paste Special Transpose won't do this. Any ideas? Ted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions |