Thanks, Max -- I'd always wondered what a "pivot table" was!

One more problem, though: I have a number of other fields besides name for
each record (address, phone, etc.). When I create the pivot table, it does a
subtotal for each additional column, each calculation constituting an
additional row. So I end up with this really long, ungainly worksheet. ANy
way to turn off the subtotaling and just have the one row per record?

Chris

"Max" wrote:

One way is to try a pivot table. Here, it'll get you a good, close-fit result
in a matter of seconds. Click Data Pivot table PivotTable .., then in
Layout (Step 3), drag n drop Name in ROW, Event in COLUMN, Event in DATA
(it'll appear as COUNT of Event), ok out.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"crcurrie" wrote:
This is probably a stupid question, but I can't figure out the answer using
the Help resources in Excel 2003.

I have a worksheet containing records of individuals and events they have
attended. Unfortunately, there is a separate row for each person for each
event attended, rather than one row per person with the events attended
checked off in columns. For example:
NAME EVENT
John Smith 12/04/2006
John Smith 10/16/2006
John Smith 06/23/2006
Mary Doe 10/16/2006
Mary Doe 04/03/2006

What I want to get to is this:

NAME 12/04/06 10/16/06 06/23/06 04/03/2006
John Smith x x x
Mary Doe x x

How do I do this in Excel 2003?