Excel: Use Multiple Value Fields as a Column or Row Field

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: When I create a table with two or more Values fields, Excel has those fields stretch across the column fields. Is it possible to change to other layouts?

Strategy: Look for a virtual field in the Column Labels drop zone called ∑ Values. This field can be pivoted to another location. It starts out in the column labels:

  1. Values go across the columns initially.

    Drag this virtual field to the Row Labels and you will get a different look to the report.

  2. You can drag Values to the row area.

For more resources for Microsoft Excel