---
title: "Joining Column Values"
description: "Joining two column values together to create a unique record ID"
url: https://help.stackby.com/en/articles/99-joining-column-values
collection: "Columns & Column types (properties)"
updated: 2025-07-01
language: en
---

# Joining Column Values

Joining two column values together to create a unique record ID

In this article we will learn to combine the values in multiple columns together with a formula column. With the help of some methods we can enhance their functionality.  

## **CONCAT()**

Concatenate links together different fields (especially characters and text) in a chain or series like a string. A simple example would first name and last name - both of which you have put in separate columns in Stackby. You need to bring both together in a separate column. Because it is text, you need to use the CONCAT formula to bring them together.

```javascript
Formula: CONCAT({First Name} ,"  " , {Last Name})
```

**Result:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/a94f4d3a3ff8cb9453722d7480d37d261c844cc6332cbbfc89604627d0f37fb01682410724275.png)

We combine several columns with the help of CONCAT() function, in the primary column it is used most commonly. You can learn more about how [CONCAT() works in primary column](https://help.stackby.com/en/articles/35-using-formula-in-primary-column.md).

## **Alternative to Concatenate** 

Concatenate is used to combine values instead of that ampersand (&) can be used as a separating character.  

**Example:** 

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/a2044762dd693e5283acd6faad4ff7cc80640ee3f8e5cca348b2bbe008ea09f51682410769864.png)

**Result:** 

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/fd3ef0b436f3bffe508d66ebb30da71d116fcb61af1b78beec85e034ad1ffd271682410797343.png)

## **Adding Line Breaks**

We combine several columns with the help of CONCAT() function, but what about if we want line breaks in between? So for that we will use "\\n" as a formula. Basically \\n is used to add line breaks for more readable result or output.  
For example, you may want to combine the more than 2-3 columns then we will use formula as 

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/54c4e5f6caca51baacc8eda16b32227d7a5593a29a504fcdef258db80c581d881682410827388.png)

**Result:  
**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/54de10b25916bc4666d907e2c06db6bc4d2ac807f2b42da3baf97d4735c523c51682410855976.png)

As we can see, the description column is not in readable form, so we can make it more impressive by using the “\\n” formula. Basically to add line break.  

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/c7182b1b448b2aa36a277e3300ac2c298f63ce1b4627718c46fa9ed27a1db68d1682410874429.png)

**Result**: 

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/402279d948478ede0c7561a08f1f6b20006f81f4a5329957bd388c73837f43251682410897119.png)

You can learn more about [how line breaks works.](https://help.stackby.com/en/articles/62-add-a-line-break-using-n.md)