Using merge cells in worksheet for Pivot Table

D

Digno

I am trying to use merge cells to establish a hierarchy in a worksheet that I
will turn into a Pivot Table. By hierarchy, I mean something like a Dog has
fleas, bones, chew toys so if I bring up Dog on the pivot table I should get
fleas, bones, chew toys to appear.

In one column I put Dog then in the column beside it and below it, I put the
list of sub-atributes. I merge the cells in the column under Dog till they
reach the end of the list of subatributes in the column beside it. It appears
like the diagram below.

Dog ?
M ?
M ?
M ?

When I put the data in the pivot table, the pivot table reads the cells
merged with the Dog cell as blank so the sub-attributes are paired with
blanks except for the one right next to Dog.

Is there someway to establish a hierarchy so that it appears in a Pivot
Table? Can this be done with merge cells?
 

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

Top