# Concatenate Columns

In this document, we will explore how to concatenate columns in Astera Dataprep.   

1. To begin, click on the *Layout* option in the toolbar and select the *Concatenate Columns* option from the drop-down.  

![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FvBM2wp9NvruYdCLuI2Ed%2F0.png?alt=media)

2. This will open the *Recipe Configuration – Concatenate Columns* panel.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FxAqgEqOVSw5pZWVdbe3t%2Fimage.png?alt=media&#x26;token=31a14cc2-e2c3-422e-9139-8a8f9c78f2df" alt="" width="380"><figcaption></figcaption></figure>

3. In this panel, you can configure the following:

* **New Column Name:** Enter a name for the new column that will hold the combined values.
* **Delimiter:** Specify the character (such as a space, comma, or dash) that should separate the values.
* **Column Name(s):** Use the drop-down to select the columns you want to concatenate.

<figure><img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FND8qxoFCQcZCQvtaaKFe%2F2.png?alt=media" alt="" width="385"><figcaption></figcaption></figure>

4. Once you're done, click *Apply* <img src="https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FrMHnhH6i6FwnFGGkYXzt%2F3.png?alt=media" alt="" data-size="line">. The new column will appear in the Grid, showing the combined values. For example, a new *PC\_Country* column.

![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FnEUd6h947aqNCDgqsg2t%2F4.png?alt=media)