Pivot table novice

[Michael]

As a teacher we tried a new data analysis tool this year in my school
which worked really well... except for the fact that it meant manually
filling in a table.
I'm sure there must be a more efficient electronic way of doing it, but
I'm not really an expert on these things.

I want to be able to put in a list of data: pupils names with scores
from two consecutive tests. Then I want to produce a table with test 1
and test 2 as the headers, and pupils' initials appearing in the
relevant box. I have managed to create a Pivot Table to show what I
want, except of course, it totals the number of pupils in each box,
rather than the individuals' names:

http://tesfaq.atspace.com/images/dataquery.htm

Can anyone explain if its possible to amend this so that, for example,
in row 4a/column 5b instead of "2", I get the initials of the relevant
pupils (CD & MN)

Or am I asking for too much?

Thanks in anticipation
Michael

 

[Debra Dalgleish]

The data area of a pivot table won't show the text from the source data.
You could put one test field, and the pupil names field, in the row area.
Put the other test field in the column area
Put another copy of pupil names in the data area, where it will show a
count.
Not exactly what you want, but it would give you a quick summary.