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?