# Split Columns

In this document, you will explore how to split columns in Astera Dataprep.    

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.

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

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

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

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.

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

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%2FUG0Hs8tQbcMmivSuNXmO%2F3.png?alt=media" 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;*.*

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

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* ![](https://3181888596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FzEifS4h8yurLAAwiGNX2%2Fuploads%2FUG0Hs8tQbcMmivSuNXmO%2F3.png?alt=media) to split the column.

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