Pivot table might work with this if you had numerical information you were
trying to summarize or you wanted to get a count. Beyond that, there is no
build in capability to do that.

--
Regards,
Tom Ogilvy

"Hman" wrote in message
om...
I have a database of customers, projects and category of projects. I
would like to create a table that would show every project by customer
by category. For examples:

Category I Category II ...
Customer 1 project a project f
project b project g
project c

Customer 2 project d project h
project e

Can anybody think of a way of doing this either using one of Excel's
existing functions (e.g., Pivot Table), VBA coding or a commercial
add-in?

I have tried fooling around with Pivot Table with little luck.
However, I have been able to create a table for one Customer at the
time using the Filter command, but I am hoping that there is simpler
way to do this.

Any help or advice would be much appreciated.

Hman