ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Columns (https://www.excelbanter.com/excel-discussion-misc-queries/37072-pivot-table-columns.html)

sharder

Pivot Table Columns
 

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


--
sharder
------------------------------------------------------------------------
sharder's Profile: http://www.excelforum.com/member.php...o&userid=25488
View this thread: http://www.excelforum.com/showthread...hreadid=390185


olasa


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

Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390185



All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com