| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IS there a way to invert rows?
I need to completely flip an address data record. Sorting does not work
because it only works by ascending or descending by fields. Is there some way of flipping rows? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IS there a way to invert rows?
On Jan 15, 10:32*am, karenb wrote:
I need to completely flip an address data record. *Sorting does not work because it only works by ascending or descending by fields. *Is there some way of flipping rows? Add a column and put number from 1 to ... Then sort that column as you need. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IS there a way to invert rows?
Records are across a row?
Enter 1 through x across a helper row. Sort that helper row "left to right" descending. Same if records are down a column. Gord Dibben MS Excel MVP On Fri, 15 Jan 2010 07:32:01 -0800, karenb wrote: I need to completely flip an address data record. Sorting does not work because it only works by ascending or descending by fields. Is there some way of flipping rows? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I invert an Excel table (collumns become rows)? | Excel Worksheet Functions | |||
| How to invert 2 series? | Charts and Charting in Excel | |||
| How can I invert an Excel List, means colums become rows and vv.? | Excel Discussion (Misc queries) | |||
| how do I invert the rows and colums in excel? | Excel Discussion (Misc queries) | |||
| How do I invert data so that the columns become rows?? | Excel Discussion (Misc queries) | |||
Linear Mode
