Group Rows By
The Group By feature allows users to organize and group rows based on a shared attribute, such as category, status, or date.
Grouping rows improves readability and simplifies navigation, especially in larger datasets. You can easily collapse and expand individual groups or the entire outline, giving you control over the level of detail you want to see.
To group rows based on an attribute, click on Group By.
Choose the column by which the records should be grouped. In the example below, we are grouping rows based on product subcategory.
To view the list of items within a group, click on the symbol '>', next to the required group name. The expanded list is shown below:
Within a group, you can create as many sub-groups as possible. Click on Add Sub Group to create a subgroup.
Choose another column to group them inside the primary group. We will select 'Model Name'.
The results are as below:
You can use the bin icon to ungroup a particular group. To return to the table, ungroup all of them by clicking the bin icon on all groups.
Note:
Click on the arrows before the group/sub-group names to expand or collapse them.
You can edit the table and perform actions like formatting, bulk-editing, inserting rows, using find and replace, sorting, etc. on grouped rows also.
Last updated