Inverting columns based on date

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:43 PM GMT

Question

I have a spreadsheet whose main body consists of one column of date data (mm/dd/yy), and six columns of numerical data. There are approximately 1,675 rows. The later dates are at the top. I need to reverse the order so that the new data is entered at the botwhile maintaining the integrity of the data (obviously). Can you help me out?

Answer

You should just be able to select all of the data, and then SORT based on date, ascending. Correct? That should keep all of your data together and just reverse the order.

Keep in mind that you're starting to get to the point where it makes sense to move up to a DATABASE program like MS Access.starts to get clumsy when you're dealing with thousands of records.

Advertisement

©2020 eLuminary LLC. All rights reserved.