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](https://i.sundulerparents.com/images/003/image-7482-1-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-2-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-3-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-4-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-5-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-6-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-7-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-8-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-9-j.webp)
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](https://i.sundulerparents.com/images/003/image-7482-10-j.webp)