We will learn how to group rows in Google Sheets. We will also have a look at nested grouping.
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.
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.
- Right Click and choose “Group rows”
- And that should group the rows.
- 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.
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”.
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”.
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.
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.
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.