> For the complete documentation index, see [llms.txt](https://docs.kognitos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kognitos.com/legacy/legacy-experience/automation-areas/tables-v2/get-rows/group-rows.md).

# Group Rows

Groups the rows of a table by specified criteria.

### Overview

This procedure groups the rows of a table by a specified column, such as "City" or "Department", and returns a list of JSON objects, where each object contains the group name and the rows that belong to it. It's useful when you need to split a dataset into meaningful categories to process each group separately, like handling orders by region or users by role.

### Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

<details>

<summary><code>group the table's rows by criteria</code></summary>

#### What does it do?

Instructs the system to group the rows of a table by certain criteria.

#### Where does it go?

This phrase should be written on a **new line**.

#### Is it required?

✅ Yes — This phrase is **required**.

#### Does it require data?

✅ Yes — A reference to **the table** must be defined. Replace **criteria** with the grouping criteria.

#### Example

```
group the table's rows by City
```

</details>

### Examples

#### 1. Group Rows by a Column

```
group the table's rows by City
use the above as the groups
process each group as follows
...
```