Menu Data--PivotTable. Next-Next-Next
Drop Class to Row field
Drop Topic to Column field
Drop Name to Data field
Right click on the count and show detail.

Please let us know if you are expecting a macro to do this...

If this post helps click Yes
---------------
Jacob Skaria