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?

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.

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?