6 Replies Latest reply: Nov 14, 2012 7:06 AM by Anand Chouhan RSS

    Crosstable

    Georgina Spary

      I think this cross table should be easy but I can't get my head around it. My source data looks like this

      StudentCourse
      123A
      123B
      124A
      124B
      124G
      125D
      125F
      125G
      126D
      126F
      127D
      127F
      128E
      129E
      130A
      131B

       

      I want to load it into this

       

      StudentABDEFG
      12311



      12411


      1
      125

      1
      11
      126

      1
      1
      127

      1
      1
      128


      1

      129


      1

      1301




      131
      1



      ...?