13 Replies Latest reply on May 20, 2017 1:49 AM by Adriaan Buys

    Pivot data that has been split - how to pivot

    Adriaan Buys

      HI There

       

      I have a data sheet with multi select columns devided by ; I have been able to split the columns. This gives me the workbook as is. I now have to pivot question 7-16 of the table. The data does not allow me to do this can anyone please advise how to pivot these columns

       

      Thank you

       

      Adriaan