# ArrayAgg

The **ArrayAgg** function identifies non-null row values in a column or group and aggregates them into a single array.

### Syntax

```
ArrayAgg(value)
```

Function argument:

<table><thead><tr><th width="274"></th><th></th></tr></thead><tbody><tr><td><strong>value</strong></td><td>(required) The column containing values to join.</td></tr></tbody></table>

### Example

```
ArrayAgg([County Name])
```

For each grouping (grouped by state name) the **ArrayAgg** function returns an array containing non-null values from the corresponding rows in the _County Name_ column.

<figure><img src="https://files.readme.io/81a6047-image.png" alt=""><figcaption></figcaption></figure>
