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 |
Merged cells and Pivot table
Johan,
Select your table, unmerge all the cells, then use Edit Go To... Special Blanks. Then press = and either the left arrow(if your merged cells were on the same row) or the up arrow (if your merged cells were in the same column) and press Ctrl-Enter. Then copy the table and pastespecial values, and you should be able to use the table as a source for pivot tables. HTH, Bernie MS Excel MVP "Johan" wrote in message ... 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 |
All times are GMT +1. The time now is 11:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com