How to Add Rows to a Pivot Table

Table of contents:

How to Add Rows to a Pivot Table
How to Add Rows to a Pivot Table
Anonim

Pivot tables are used to group and organize data in a spreadsheet. The primary advantage of pivot tables is that you can organize and manipulate data in a variety of ways, based on user needs and the conclusions that can be drawn from the information. The data in a pivot table can be organized and shown in a different way by adding new rows. This article will show you the steps to add rows to a PivotTable in order to provide different depth and meaning to the information shown.

Steps

Add Rows to a Pivot Table Step 1
Add Rows to a Pivot Table Step 1

Step 1. Run Microsoft Excel and open the file that contains your pivot table and source data

Add Rows to a Pivot Table Step 2
Add Rows to a Pivot Table Step 2

Step 2. Select the tab that contains the data

Add Rows to a Pivot Table Step 3
Add Rows to a Pivot Table Step 3

Step 3. Check your data organization

The column names in the source data are usually used as the field names in the pivot table

Add Rows to a Pivot Table Step 4
Add Rows to a Pivot Table Step 4

Step 4. Compare the source data with the pivot table and try to figure out which columns to add, showing them as row labels

Add Rows to a Pivot Table Step 5
Add Rows to a Pivot Table Step 5

Step 5. Go to the tab containing the pivot table

Add Rows to a Pivot Table Step 6
Add Rows to a Pivot Table Step 6

Step 6. Force "Pivot Table Field List" or "Pivot Table Wizard" to run by clicking one of the cells inside the pivot table area

Add Rows to a Pivot Table Step 7
Add Rows to a Pivot Table Step 7

Step 7. Click the column of interest, drag it to the "Row Labels" section of the Pivot Table Field List

Add Rows to a Pivot Table Step 8
Add Rows to a Pivot Table Step 8

Step 8. Reorder the fields in the "Row Labels" section and you will see the change propagate to the pivot table

Add Rows to a Pivot Table Step 9
Add Rows to a Pivot Table Step 9

Step 9. Select the row order that best suits your needs

Add Rows to a Pivot Table Step 10
Add Rows to a Pivot Table Step 10

Step 10. Adjust the spreadsheet layout to best display the newly added rows

Recommended: