reports excel 2007
 

I have a very large spreadsheet with the first column showing dates of all
weekdays from 1/2/1900 through the present. the rest of the columns (about
500 of them are different categories. Each date may have one or more of
those categories. Eacch row consists of a date, withabout 500 cells across
which may or may not have data, (Usually a 1, or a -1, or a 0 or a 2 or a
4)depending on which category it is. I need to keep the spreadsheet this
way, but I need something else that will show me on the leftr column the
dates, and the rows across will show only those categories that have data in
it.

This is what my spreadsheet looks like now, in miniature.
DAte Category1 Category 2 Category 3
1/2/00 1
1/3/00 2 0
1/4/00 1
1/5/00 1 1

Th is is what I need to see
Date whichcategory? Which Category? Which Category?
1/2/00 Category 2
1/3/00 Category 1 Category 3
1/4/00 Category 1
1/5/00 Category 2 Category 3

I hope this is clear. Thank you.
newyorkjoy
thanks for the help!