Home

How to sort this data in the other way?

Dannni_Yea1240
Occasional Contributor

Hi! I have this data file where all the data is in non ascending order. I want this data set to go from  1999-12-31 in A1 to 2016-11-30, is this possible, while at the same time shifting all the other values for the stocks. 

3 Replies
Select your data range and press Alt,A,S, then sort by Column A.
I was able to sort by date but this is not the way I want it to, i just want to "flip" the data set if that is possible.