Merged cells and Pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging cells in Pivot tables 1
Pivot Table Help 1
Pivot table filter list - listing irrelevant subcategorys 1
Creating a pivot table which resembles a SQL 'group by' 2
Pivot Table 2
Pivot Table Formula Problem 1
QUESTION: How can I conditionally compute data in a pivot tables? 1
Adding to an existing Pivot Table 7

Back
Top