inverting data

  • Thread starter Thread starter I Maycotte
  • Start date Start date
I

I Maycotte

I'm wondering if it's possible to invert data so that what is up at th
top will now be at the bottom and what is at the bottom will now be u
at the top. This would be easy if I had only a few rows o
information, but I have hundreds. Thanks in advance.

-- Isaa
 
You can temporarily add a 'helper' column next to your column of data, and
then number it from 1 to whatever.
Select both columns and sort on the 'helper' in descending order.

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

in message
I'm wondering if it's possible to invert data so that what is up at the
top will now be at the bottom and what is at the bottom will now be up
at the top. This would be easy if I had only a few rows of
information, but I have hundreds. Thanks in advance.

-- Isaac
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to invert Cols/Rows? 2
inverting data and multiplication 0
Bar Chart With Custom Labels On X and Y? 0
how do u reorder data in a column so last cell entry is first? 7
Crosstab with some 'empty' rows 2
How do you invert legend data? 1
Pivot Table Help! 1
Invert a column of data. 4

Back
Top