Pivot tables and merged Cells

D

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

*** Sent via Developersdex http://www.developersdex.com ***
 
J

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
 

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