6 Replies Latest reply: Mar 26, 2015 5:27 AM by Priyanka Pandey RSS

    Transformation of Table

    Priyanka Pandey

      Hi Team,

       

      I want to convert table1 into table2. Please help.

       

      Table1:

      StudentPaper-IPaper-IPaper-IPaper-IIPaper-IIPaper-IIPaper-IIIPaper-IIIPaper-IIIPaper-IVPaper-IVPaper-IV
      TypeExternalInternalPracticalExternalInternalPracticalExternalInternalPracticalExternalInternalPractical
      A413332373139393237433045
      B393447312944383347453749
      C282737322944383244283148
      D363247443549343147292745

       

      Table2:

      Student NamePaper TypeMarks
      APaper-IExternal41
      APaper-IInternal33
      APaper-IPractical32
      APaper-IIExternal37
      APaper-IIInternal31
      APaper-IIPractical39
      APaper-IIIExternal39
      APaper-IIIInternal32
      APaper-IIIPractical37
      APaper-IVExternal43
      APaper-IVInternal30
      APaper-IVPractical45

       

      Regards

      Priyanka