In this article, we will learn how to group rows in Google Sheets. We will also have a look at nested grouping of rows in Google Sheets.
Grouping is when we group some rows or column together to make our sheets neater. We can use it to club together related data because showing too much data at once can make our data overwhelming and working with it tedious and inefficient. Also its helpful to keep our database sorted in a fashion.
How to group rows in Google Sheets
Let’s us consider the following data shown in the image as an example to group rows in Google Sheets.
The data contain, as you can see, 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–and not the individual members–are shown which can be expanded to see each team member’s performance.
To group the rows in Google Sheets of the teams, follow the given steps given below.
- Select the rows that you want to group. Make sure you select the rows and not just the cells.
- Right click anywhere in the selected rows and hover the cursor to “View more row actions”. Then select “Group rows” to group the selected rows.
- And that should group the rows.
- Clicking on the “-” sign would collapse it.
- Instead of right clicking and selecting the group rows option, you can also use Alt+Shift+Right arrow to group the rows automatically.
- After all the rows have been grouped, the table looks as show below.
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” to create a nested group.
You can expand it using the sign. But for large tables with many groups it can be time consuming to expand each of the groups individually. 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.
How to Group of columns in Google Sheets
Grouping columns in Google Sheets in no more difficult than it is to group rows. The steps to group columns in Google Sheets is the same as for rows. Simply select the columns you want to group. Then right click and select “Group Columns”. Or you can use the shortcut–Alt+Shift+Right Arrow.
The selected columns will be grouped. Click the minus sign (-) to collapse the grouped columns and the plus sign (+) to expand the columns.
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 Google Sheets 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.