I'm using Outlook 2002, and I need to generate a spreadsheet of my
contacts names that will show the name in the row and the categories
by column, one category by column. I know that Outlook can generate a
listing of categories with names, but what I want is a sheet in which
I can look across to see which categories a person is pegged to and who else is
in those categories. I've tried the export to Excel, but that just gives
me all of a person's categories in the same cell.

---

Request for Question Clarification by hammer-ga on 13 Dec 2002 05:51 PST

So, you have this...

Name            Category
------------------------------------------------
John Doe        Business, Personal, Marmoset
Jane Smith      Marmoset
Ted Jones       Personal

... and you want this?

Name        Business        Personal        Marmoset
-----------------------------------------------------
John Doe        X               X               X
Jane Smith                                      X
Ted Jones                       X

Is this correct? If not, please describe what you want the output to look like.