# Group Rows

### 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
...
```