Thank you but what do you mean:
"Right click on the count and show detail."
if I right click on the "Count Name" I do not have this option.
If I right click on any of the counted cells then I do have the option but
if gives me a new table only for that count, I need to see all the data in
one table.
(I have excel 2003)



"Jacob Skaria" wrote:

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