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,




      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.