Pivot Tables-2 Questions
 

Question # 1

I have a pivot table that's laid out similar to below.
Cell 1 | 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.

Cell 1 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...