View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johan
 
Posts: n/a
Default Merged cells and Pivot table

I have the following tabel
A B C
Region Customer Product
1 ASIA Custo Apple

Since one customer can have more products and a region more customers I used
in the table mergd cells to keep the overview. However when I am using this
data in my pivot table only the first complete row is stated in the pivit
table. Any ideas how to solve this?

regards

Johan