How to Add Rows to a Pivot Table

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

Table of contents:

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:

How to Add a Column to a Pivot Table

How to Add a Column to a Pivot Table

This article explains how to create and insert a new column in a PivotTable in Microsoft Excel with the PivotTable tools. You can turn a row, field or value into a column, or create a new one calculated with a custom formula. Steps Method 1 of 2:

How to Add Data to a Pivot Table: 11 Steps

How to Add Data to a Pivot Table: 11 Steps

This article explains how you can add new data to an existing Microsoft Excel PivotTable. You can perform this change on both a Windows and a Mac computer. Steps Step 1. Open the Excel file which contains the pivot table Double-click the document icon to open it directly in Excel.

How to Add a Custom Field to a Pivot Table

How to Add a Custom Field to a Pivot Table

On some occasions, you need to enter more information than a normal pivot table can show. In these rare cases, it might be helpful to add a custom and calculated field to the pivot table. You can configure these fields to show averages, percentages, or the maximum and minimum values of a field.

How to Change the Data Source of an Excel Pivot Table

How to Change the Data Source of an Excel Pivot Table

The Microsoft Excel program is designed to allow users to sort and interpret data using advanced features such as pivot tables, formulas and macros. It may happen that a user wants to modify the input data to carry out evaluations on the results.

How to Add a Filter to a Pivot Table

How to Add a Filter to a Pivot Table

PivotTables can provide great support for analyzing the data in a worksheet, but sometimes even the best (best designed) PivotTable can show more information than needed. In these cases, it may be useful to add filters. Once set, a filter can be changed to suit the viewing needs of different users.