Select columns
In this exercise, you'll further populate your pivot table by selecting the Column Labels.
You will populate the Columns by selecting among the following categories: Name, Headquarters, and Industry.
You'll start by selecting a single Column Label, then removing it, then you'll select multiple Column 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 Columns section, and choose
Industry; this will list each industry in the dataset. - Now click the X in the upper right section of the
Industrybox in the pivot table editor, this will remove the names. - Now select Add and choose
Year, select Add again, and chooseHeadquarters.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise