4 Replies Latest reply: May 11, 2015 7:02 AM by Ignacio Cifuentes RSS

    Draw table with data related in the same table

    Ignacio Cifuentes

      Hi,

      I´ve got the following data

       

      FileNameIDTargetIDFlagTargetID
      File_1Name_Axxx-1110
      File_1Name_Byyy-222xxx-1111
      File_1Name_Czzz-333yyy-2221
      File_2Name_Daaa-4440
      File_2Name_Ebbb-555aaa-4441
      File_2Name_Fccc-666bbb-5551
      File_2Name_Gddd-777ccc-6661
      ....................

       

      and I would like to know how can I draw the following pivot table or similar.

       

      FileName
      File_1
      Name_A
      Name_B
      Name_C
      File_2
      Name_D
      Name_E
      Name_F
      Name_G
      ...............

       

      can any one help me please.

       

      Thanks It advance