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?