4 Replies Latest reply: Feb 8, 2018 5:41 AM by Daemon Maxwell RSS

    Combining Pivot Tables into one table

    Daemon Maxwell

      Hi,

       

      Now you're probably thinking I should have used the search function. I did, but unfortunately can't find my exact problem with a solution, so here goes

       

      If I have a table like so:

       

        

      NameColourJobCityDate
      1GDriverLondon01/01/2016
      2RWalkerParis02/01/2016
      3BSwimmerParis01/05/2016
      4RSwimmerNY03/06/2016
      5GDriverDakar17/06/2016
      6BSleeperTimbuktu02/12/2017

       

      I can create Pivot tables that look like:

       

      pivotmerge test1.JPG

       

      I would like to be able to combine those tables so that the caption and Date line don't appear on the second table and the City lines appear directly below the Name lines, like an Excel KPI based on 'Date' would look like. ie:

       

       

      pivotmerge test2.JPG

       

      Many Thanks