Pivot Tables

  • Thread starter Thread starter BobF
  • Start date Start date
B

BobF

Two questions dealing with Pivot Tables.

1. Is it possible to merge 2 separate pivot tables into 1
provided they have a common field?
2. Is it possible to arrange multiple data fields as
columns rather than rows in a pivot table?

Thanks in advance.
 
1. Perhaps you could combine the data from the two source tables, and
create a pivot table from that.

2. Drag the Data field button onto the cell which contains the word
'Total', and the fields will be arranged horizontally. There are
instructions here:
http://www.contextures.com/xlPivot02.html
 
Back
Top