reply to nickstoy
Re: [Excel] Add all fields to pivot table (in Row Labels) (Excel I just add all fields in the table (Select all data on the sheet), add to report filter, then on the actual A1 cell you should have the field name (All) with a drop down but at the bottom is select multiple items check box.
It appears you simply created a list of Baking needs vs. categories to place into a table? All those items would be in a column labeled 'Baking Needs' with a separate column of 04x78 and 08x78 in another column or something along those lines?
Im not sure what you mean in your explanation.
The pivot comes from a DB which stores thousands of planograms, for hundreds of catefories (you only see baking in the pic), and which product (UPC) is carried on which planogram.