3 Replies Latest reply on Nov 10, 2016 6:47 PM by Sherzodbek Ibragimov

    How to create pivot table without pivoting my data source?

    Ruofei Wang

      Hi all,

       

      I have a problem here. How to create pivot table without pivoting my data source? Because I want to automate my process and "pivot " step will need someone to click it.

       

      My data looks like this:

       

      ID1ID2log1log2log3log4log5other data
      11FTF1
      12TTT2
      13TFT3
      14TTT1
      25FTT1
      26TFT1
      27TTT123
      28TFT1
      39TTT121
      310TFT12
      311TTT13
      312FTT2

       

      I want it to be converted into this table:

       

      FTNull
      ID1=1log1Count how many ID2
      log2
      log3
      log4
      log5
      ID1=2log1
      log2
      log3
      log4
      log5
      ID1=3log1
      log2
      log3
      log4
      log5

       

      Could anyone help?

       

      Thanks.