Pivot Table with merged cells
Posted on 2011-09-06
I have a simple pivot table that I have attached where I have a set of merged cells in the columns and then two variables under each merged cell. I'm trying to use a pivot table to begin to do some analysis and have found that I may not be able to use merged cells in a pivot table.
I'd appreciate it if someone would take a look at this sample and give me some ideas on how to attack the problem of using a pivot table for this type of simple analysis.
Thank you in advance.