32 Replies Latest reply: Jun 29, 2017 6:57 AM by Sunny Talwar RSS

    Collating Months in Quarters

    Alison Cooke

      Hello All,

       

      I have a number of tables which have been concatenated. I have then used the FileBaseName() function to retrieve the Excel filename and, thus, identify the month the data pertains to.

       

      Would it be possible to organise this data into a quarter? If so, please let me know.

       

      All the best,

      Alison

       

      P.S

      If it's possible, please can provide a description of how the solution works as if I am just provided with the function, I find it difficult to understand how and why it works.