How to group rows in Google Sheets | 2 min easy guide

How to group rows in Google Sheets | 2 min easy guide
Reading Time: 4 minutes

We will learn how to group rows in Google Sheets. We will also have a look at nested grouping.

Group rows in Google Sheets
Group rows in Google Sheets

Grouping is when we group some rows or column together to make your sheets neater. You should use it to club together related data because showing too much data at once can make your sheet overwhelming. Also its helpful to keep your database sorted in a fashion.

Group Rows in Google Sheets

Let’s say we have a table that looks like this.

Sample table
Figure 1: Sample Table

It contains sales data on an organization. There are three teams and each team has two members. For example, Team 1 has Joey and Chandler. Now we would want to group these rows such that, only the sales figures of teams are shown which can be expanded to see each team member’s performance.

To achieve the written, follow the given steps

  • Select the rows that you want to collapse. 
Selecting rows to group
Figure 2: Selecting rows to group
  • Right Click and choose “Group rows”
Grouping rows together
Figure 3: Grouping rows together
  • And that should group the rows.
Collapsing and expanding data
Figure 4: Collapsing and Expanding data
  • Clicking on the “-” sign would collapse it. 
  • Now rather than right clicking and selecting the group rows option, you can also use Alt+Shift+Right arrow to group the rows automatically.
  • Eventually the table would look something like this.
Resultant table
Figure 5: Resultant Table

Nested Grouping of Rows

You can also group already grouped arrays. To do so just expand the grouped array and then select all rows and do the same step as before i.e. use the shortcut or right click and click “Group rows”.

Nested grouping of row in Google Sheets
Figure 6: Nested Grouping of Rows in Google Sheets

You can expand it using the sign but for large tables it can be time consuming. So another way to do it is by right clicking on the side icon and then choosing ”Expand all row groups”.

Expanding all row groups at once
Figure 7: Expanding all rows at once

This should expand all the rows.

Grouping of columns

Grouping columns is pretty easy as well. You have to follow the same steps but you have to select the columns. Then right click and select “Group Columns”. Everything else should be the same.

Conclusion

We saw how to group rows in Google Sheets so that they can be collapsed or expanded. We also saw how to Group rows in a nested fashion. Apart from this, we also leant how to group columns in Google Sheets. You can read more about grouping in the official documentation here.

See Also

You can check out other equal good articles on Google Sheets here.

How to import JSON in Google Sheets: See how to work with JSON using Apps Script Editor. Convert JSON data from a URL to Google Sheets table.

Using Vlookup and Hlookup together: Learn how to reference data from other sheets in Google Sheets including sheets from a different spreadsheet files.

How to Create Google Calendar Events from Google Sheets: Learn how to create Google Calendar events from Google Sheets.

ARRAYFORMULA in Google Sheets: Learn how to use the ARRAYFORMULA function in Google Sheets and its variations.

Delete Empty rows in Google Sheets: In this article we would see how to delete empty rows in Google Sheets using two different ways.

How to group rows in Google Sheets: We will learn how to group rows in Google Sheets. We will also have a look at nested grouping.

10 responses to “How to group rows in Google Sheets | 2 min easy guide”

Leave a Reply