Pivot Tables-2 questions

Giganews Newsgroups
Subject: Pivot Tables-2 questions
Posted by:  CrimsonPlague29
Date: Fri, 5 May 2006

Question # 1

I have a pivot table that's laid out similar to below.
            |            Build Cell 1                |        Build Cell 2
----------|--------------------------------------|--------------------------------------
Part #  |    Prod A  Prod B  Prod C  Prod D |  Prod A Prod B Prod C Prod D
123      |    3            1                |                3      1
456      |    4    1                |              2
789      |    5                    |                4    
----------------------------------------------------------------------------------------
I would like it to look like the chart below.  Only showing the products
that are being produced in that specific Cell automatically when the pivot is
created.

          |           Build  Cell 1      |      Build Cell 2    
--------|---------------------------|---------------------------
Part # |    Prod A    Prod B    |    Prod C    Prod D
123    |    3    1          |      3        1
456    |    4    1          |            2
789    |    5                |      4    

Question #2
How can you set the pivot table to automatically add a data column once it's
entered into the main data area without having to go into layout and manually
adding???
  eg. add part # for product E and have it appear in the Cell 2 section

Thanks in advance for any help...

Replies