Solved Invert data in Excel

Microsoft Excel 2010 - complete product...
December 8, 2015 at 22:08:26
Specs: Windows 10, i5 / 8Gb
Probably simple: I have a table of data in Excel. I wish to invert the table so (say) row 10 becomes row 1, row 9 becomes row 2 etc. Thought I could double transpose but had no joy (reverted back to original on second transpose)

See More: Invert data in Excel

Report •

December 9, 2015 at 04:45:07
Quick way is to insert a Helper column,
in the Helper column enter the numbers 1 thru 10
then do a Reverse Sort on the whole table using the helper column.

See how that works for you.

EDIT: Just to be clear, by Reverse Sort,
I mean sort Largest to Smallest on the Helper Column.


message edited by mmcconaghy

Report •

December 9, 2015 at 12:11:01
✔ Best Answer
This might quicker, plus it automatically updates:

With your data in A1:A10, enter this in B1 and drag it down:


EDIT: Yes, it creates a separate table.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •

December 16, 2015 at 01:10:12
Thanks for both responses - both helpful. I selected the =INDEX solution as most helpful. However use of the "Helper" option yet again taught me that you can often find a work around which will achieve your objective without the need for knowing the direct solution.

Report •
Related Solutions

Ask Question