Pin Me

Microsoft Excel: Use Multiple Data Fields As A Column Field

written by: Mr Excel•edited by: Tricia Goss•updated: 11/18/2011

Problem: When you create a table with two or more Data fields, Excel will default to having the various Data fields be like the innermost Row field, as shown in Fig. 916. This is not the most useful view of the data. It would be preferable to have the three data columns going across the columns for each product.

  • slide 1 of 2

    Strategy: When you have more than one field in the Data area, you will find that a new button appears on the pivot table that is called Data, as shown in Fig. 917. You can drag the Data button from the Row field to the Column field.

    Summary: Although the default view of the pivot report for multiple Data fields is unusual, you can easily correct it by moving the Data field to the Column area.

    Commands Discussed: Data – PivotTable

    See all Microsoft Excel tips

  • slide 2 of 2


    Fig. 916Fig. 917