Pivot tables and merged Cells

[Darin Kramer]

Howdie

Does a pivot table work with Merged Cells? Conceptually difficutl as
output is in single cells but input is in multiple cells. I need to use
pivot table functionality, but over merged cells. Any ideas?

Thanks

D

 

[Jon Peltier]

Another good reason to avoid merged cells. If you can't change them in the
source data, make a copy of the source with no merged cells and use this as
the real source.

- Jon