Is there a way to transpose and invert the order of data in Excel.

G

Guest

I have a worksheet with ascending years and I want to have the years descend.
I need to learn how to invert the data without having to manually re-enter 30
years worth of data.
 

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

Manipulating matrices of unknwon (a priori) size 1
Invert a column of number 2
reverse or invert column data 1
inverting data for a graph 6
Invert a matrix larger than 52 x 52 using MINVERSE 1
Invert a column 5
How do I invert an Excel table (collumns become rows)? 1
Grouping data 6

Top