We are creating a web app for doing teacher gradebooks.

Each student appears in the gradebook for a class once - and has many columns. And to make matters worse each gradebook has a variable number of columns.

The data for each cell of the grid is stored in it's own row - like this:

Code:
StuId Column Score
  1      1     99
  1      2     98
  1      4     97
  2      1     88
  2      3     87
  3      1     50
  3      2     51
  4      4    100
What I need to give the web page is a recordset that looks like this

Code:
StuId Col1 Col2 Col3 Col4 Col5 Col6 ...
  1    99   98        97
  2    88        87
  3    50   51
  4                  100
Any suggestions on how to accomplish this would be appreciated!