7 Replies Latest reply on Nov 11, 2016 9:41 PM by Norbert Maijoor

    how can i create a crosstab using same variable on rows and columns

    Ezequiel Galarce

      Hi,

       

      I'm trying to create a crosstab showing progress across two student tests. I have three columns (test, student, grade):

       

             

      teststudentgrade
      1za
      1yb
      1tc
      1xd
      2zc
      2yd
      2ta
      2xa

       

       

      and would like to report the data in a crosstab like this:

       

       

             

      test 1abcd
      test2
      a# students# students# students# students
      b# students# students# students# students
      c# students# students# students# students
      d# students# students# students

      # students

       

      but not sure how to how about it. i'm sure it's pretty straightforward but can't figure it out.

      all suggestions are welcomed.

      thanks