IS there a way to invert rows?

  • Thread starter Thread starter karenb
  • Start date Start date
K

karenb

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?
 
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?
Click to expand...

Add a column and put number from 1 to ...

Then sort that column as you need.
 
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
 
Back
Top