Hi

I use Excel 2000

I have a worksheet that has duplicate (or more) entries in some columns.

When I generate the pivot table these items that are duplicated only display
once on the table and there is a blank line/s under them.

Example

GREY 555 AAA
555 ZZZ
BLUE 666 BBB
666 CCC

I would like that if there is a duplicataion of an entry that that
duplication also shows on the pivot table. In the case of the example above
that the work GREY & BLUE shows up in every line of the pivot table.

How do I format the pivot table not to hide the duplicates.

Thanks

John