# Group Rows By

The 'Group Rows' feature in EDITable lets you group the rows based on a selected column. Rows with the same attributes are grouped.

1. Click **Group** from the toolbar.

<figure><img src="/files/ftCgJktZOBKI6vgPewNS" alt=""><figcaption><p>Group</p></figcaption></figure>

2. Select the column to group by. In the example below, we are grouping rows based on the department ID.

<figure><img src="/files/rhpgoscAacmY4YJa7AR8" alt=""><figcaption><p>Group By</p></figcaption></figure>

3. Within a group, you can create sub-groups. Click on **Add Subgroup** to create a subgroup.

<figure><img src="/files/kj2RxGs1gToVNKqnmVVO" alt=""><figcaption><p>Add Subgroup</p></figcaption></figure>

4. Select another column to group them. We will select 'TargetBonus'.

<figure><img src="/files/WFIptHnS8mc5rVpPFkBZ" alt=""><figcaption><p>Grouping by another column within a group</p></figcaption></figure>

The results are as below:

<figure><img src="/files/K37ScaHjJBl5ROedkTbp" alt=""><figcaption><p>Groups and sub-groups</p></figcaption></figure>

5. Use the arrows to expand or collapse the groups and sub-groups.&#x20;

<figure><img src="/files/OcK0Jm7rnTWIQmOAuUl0" alt=""><figcaption><p>Expand/Collapse</p></figcaption></figure>

6. Use the three-dot menu to expand all/collapse all or insert a row.

<figure><img src="/files/FrE9SKodmsR5iotnj7ZS" alt=""><figcaption><p>Menu options to expand/collapse/insert</p></figcaption></figure>

7. You can edit the table, and perform usual actions like formatting, bulk-editing, inserting rows, using find and replace, etc. on grouped rows too.

<figure><img src="/files/KMlJt1CCKxhrzyG67rbu" alt=""><figcaption><p>bulk-editing after grouping</p></figcaption></figure>

8. You can use the bin icon to ungroup a particular group. To return to the table, ungroup all of them by clicking delete on all groups.

<figure><img src="/files/AcWSiCgUTXDuWP7aU4Um" alt=""><figcaption><p>Ungroup/delete group</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inforiver.com/editable/working-with-editable/explore-data/group-rows-by.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
