You're not doing anything wrong. If you create a Pivot Table from
multiple consolidation ranges, as you discovered, you won't get the same
pivot table layout that you'd get from a single range. There's an
example he

http://www.contextures.com/xlPivot08.html

If possible, store your data in a single worksheet, and you'll have more
flexibility in creating the pivot table.


winwinweb wrote:
Hello, I am trying to use the pivottable function with two different
worksheets of sales data. The worksheets have some of the same columns, but
each worksheet has its own unique data as well. I'm trying to combine into
one worksheet, but when I do, I cannot display the details for each customer
profile. It will only display as all in one column, or all in one row. The
only way I can see the details is by double-clicking on a particular cell,
which then opens a separate worksheet with the detals for that particular
column. Any suggestions?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html