Forum Discussion

Dannni_Yea1240's avatar
Dannni_Yea1240
Copper Contributor
Mar 04, 2019

How to sort this data in the other way?

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. 

BI & Data Analytics
Need Help

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 04, 2019
    Select your data range and press Alt,A,S, then sort by Column A.
    • Dannni_Yea1240's avatar
      Dannni_Yea1240
      Copper Contributor
      Mar 04, 2019
      Hi!

      I'm only able to sort by this?

      https://i.gyazo.com/c1cb254f05da1faa34c3cc9da6f17208.png
      • Dannni_Yea1240's avatar
        Dannni_Yea1240
        Copper Contributor
        Mar 04, 2019
        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.

Resources