Please provide us with some more information. It is really hard to understand what the problem is if you don't show us the intial/source data. Why do you need a pivot table for this type of table - It can just as easily be created with a regular table?
