AS you can see in the attached file, I have several collumns of data going form 2012 to 1992. I would like to know the quickest way to invert this so the data is presented 1992 to 2012.
Thanks very much for your help and have a good Christmas,
Thanks,
What is your actual excel Version?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Go to the Data Ribbon, and on the Sort Icon, you will find an options button. Click this and select Left to Right.
Merry Christmas to you too!
David
My Excel version is 2003 thanks
Please update it in your profile too.. Because at present it is showing 2010
Select the Column Header>>Data>>>Group & Outline>>Group
Do this for the columns which you would like to hide.
Press 1 & 2 which is getting created in the Left Side Above to Column Headers to move quickly
Yes you can...
so for this u need to first name on cell a1 as "year" select the entire data copy (ctrl+c) and then go to another sheet and then paste it as paste special (alt + e+s+e)then choose there as transpose and now select again the whole data and sort (alt + d+ s) based on year ( older first and then newer).
once you have sort data copy it one more time and paste in the sheet 1 and paste as special choose there as transposee....
many thanks
R
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks