Group By option in Sheets

The Group by option helps you to group the entries of the sheet based on the values of one column in an ascending or descending order. For example, you can group the employees based on the department they work in or you can group the devices based on the brand.


You can group the entries by clicking on the “Group by” option in the top bar and select the column you want to use to group the entries. You can then select whether you want to group them in an ascending or descending order.

You can expand or collapse each group by using the icon at the start of the row. And can also add new rows to any group.