If you've seen my reply to ikegami, You can see that I've added IDs in my example.
| [reply] [Watch: Dir/Any] |
Given this table :
Student Subject Grade
------- ------- -----
Joe Reading A
Joe Writing B
Joe Arithmetic C
Mary Reading B-
Mary Writing A+
Mary Arithmetic C+
A pivot table created using the columns "Student" and "Subject" and th
+e value "Grade" would yield :
Student Arithmetic Reading Writing
------- ---------- ------- ----------
Joe C A B
Mary C+ B- A+
Because I forgot all about VIEWS/PIVOT, I did the transformation manually. | [reply] [Watch: Dir/Any] [d/l] |