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