exceller
Thread Starter
- Joined
- Dec 2, 2003
- Messages
- 411
I have a spreadsheet using Excel 2003 recently created.
There are some 10 columns with numbers in each cell, starting from February 2015 in line No.14 down to line 1000 with a date January 2007..
What I want to do is to invert all the data, so Jan 2007 is at the top of the listing and Feb 2015 is at the bottom, (basically turning it all upside down).
Reason for this, is when I add new data it can be added to the existing listing at the bottom without effecting the current listing.
If I copy and paste new data to the top of the current listing, this overwrites the existing listing.
thanks
There are some 10 columns with numbers in each cell, starting from February 2015 in line No.14 down to line 1000 with a date January 2007..
What I want to do is to invert all the data, so Jan 2007 is at the top of the listing and Feb 2015 is at the bottom, (basically turning it all upside down).
Reason for this, is when I add new data it can be added to the existing listing at the bottom without effecting the current listing.
If I copy and paste new data to the top of the current listing, this overwrites the existing listing.
thanks