Pivot Table Columns

[sharder]

Is there any way to make the columns fill down in a pivot table? Some of the people seeing the reports get confused easily. In the example below is there any way to make the parent copy down on the next two rows?

PARENT QUANTITY PO_NUMBER
S00396 49 S07265-00
-------- S07272-00
-------- S07295-00
S00397L 62 S07265-00

Thanks
Sharder

[olasa]

I think this will help you:
http://www.excelforum.com/showthread.php?t=384081

Ola Sandström