# Split Columns

In this document, you will explore how to split columns in Astera Dataprep.   &#x20;

1. To split columns in Astera Dataprep, click on the *Layout* option in the toolbar and select the *Split Columns* option from the drop-down.

![](/files/duqSLfZfCMsTfEJL8f0f)

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

<img src="/files/5xf4VVe9LxWs7501yGMo" alt="" width="504">

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

* **Column Name:** Choose the column you want to split.
* **Delimiter:** Enter the character (like a space, comma, or dash) that separates the values.
* **New Column Names**: Specify the names for the new columns that will hold the split values.

![](/files/m9cSxzre1ehkWa4eYk1V)

4. Once you're done, click Apply <img src="/files/6gBLFXJUDbXZagYyEIv3" alt="" data-size="line">. You’ll see in the Grid that your selected column (for example, *CustomerName*) has been split into new columns (like *FirstName* and *LastName*) based on the delimiter you provide&#x64;*.*

![](/files/3Q2pyHcgCZAI7MMDauzS)

5. Alternatively, you can right-click on a column header directly in the Grid and select *Split Columns* from the menu. The configuration panel will open with the selected column pre-filled. Make any changes you need and click *Apply* ![](/files/6gBLFXJUDbXZagYyEIv3) to split the column.

![](/files/Rt0I4hJ7OuHpwlXTWeiZ)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.astera.com/dataprep/layout/split-columns.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
