---
title: COMBINE_COLUMNS_AND_ROWS
url: https://www.tines.com/docs/formulas/functions/combine-columns-and-rows/
kind: formula-function
---

*[tines.com](https://www.tines.com/llms.txt) › [Docs](https://www.tines.com/llms.txt) › [Formulas](https://www.tines.com/llm/docs/formulas.md) › [Functions](https://www.tines.com/llm/docs/formulas/functions.md)*

# COMBINE_COLUMNS_AND_ROWS

*[View on tines.com](https://www.tines.com/docs/formulas/functions/combine-columns-and-rows/)*

Combines labeled columnar data into a list of objects. Useful for processing data returned from APIs like Snowflake, Databricks, or Google Sheets.

**Categories:** Data Parsing/Conversion

## Syntax

```
COMBINE_COLUMNS_AND_ROWS(columns, rows)
```

## Examples

### Example 1

Input:

```json
{
  "cols": [
    "Name",
    "Age"
  ],
  "rows": [
    [
      "Alice",
      35
    ],
    [
      "Bob",
      51
    ]
  ]
}
```

Formula:

```
COMBINE_COLUMNS_AND_ROWS(cols, rows)
```

Output:

```json
[
  {
    "name": "Alice",
    "age": 35
  },
  {
    "name": "Bob",
    "age": 51
  }
]
```