Select rows
In this exercise, you'll begin to populate our pivot table by selecting the Row Labels. On the right, you'll find the blank pivot table that was created in the previous exercise, containing the Top 10 companies by Revenue for 2017.
You will populate the Rows by selecting among the following categories: Name, Headquarters, and Industry.
You'll start by selecting a single Row Label, then removing it, then you'll select multiple Row Labels
This exercise is part of the course
Pivot Tables in Google Sheets
Exercise instructions
- Select Add in the pivot table editor next to the Rows section, and choose
Name; this will list the name of each company in the dataset. - Now click the X in the upper right section of the
Namebox in the pivot table editor, this will remove the names. - Now select Add and choose
Headquarters, select Add again, and chooseIndustry.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise