Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
formulas referencing pivot table cells | Excel Worksheet Functions | |||
Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions |