3 Replies Latest reply on Oct 5, 2016 9:04 AM by Ruofei Wang

    How to create pivot table like this?

    Ruofei Wang

      Hi all,

       

      I have a problem here. My data looks like this:

       

      ID1ID2log1log2log3log4log5
      11FTF
      12TTT
      13TFT
      14TTT
      25FTT
      26TFT
      27TTT
      28TFT
      39TTT
      310TFT
      311TTT
      312FTT

       

      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.