# Separate

Separates a column with delimited values into multiple columns or rows.

## Separate a Column into Multiple Columns

### How to Access This Feature

#### From + (plus) Button

![](/files/-M4oN9ReNGNkxd3ONFmZ)

* Click "+" button and select "Separate".

#### From Column Menu

![](/files/-M4oN9Rk6IZMhIkBbu7h)

* You can also select "Separate" from the column menu of the column to separate.

### How to Use This Feature

![](/files/-M4oN9Rn8fLF-hTCblLT)

1. Select column to separate from "Column to Separate" dropdown.
2. Specify separating text by selecting one from "Separate by" dropdown.
3. Specify names of resulting new columns, separated by comma, in "New Column Names" text field.
4. Specify parameters in the "Parameters" section.

* Remove original column - The default is TRUE. Set FALSE to drop the original columns.
* Guess column data type - The default is FALSE. Set TRUE to automatically guess the most possible data type for the columns in the result.
* Drop or merge extra values - The default is "warn". Set "drop" to drop any text beyond the number of the new columns, "merge" to merge the text with the value in the last column.
* NA goes to - You can control what happens when there are not enough pieces. Leaving it "Choose..." fills from the right. "Right" fills with missing values on the right. "Left" fills with missing values on the left.

1. Click "Run".

## Separate a Column into Multiple Rows

### How to Access This Feature

#### From Column Menu

![](/files/-M4oN9Rrz9OBxMLe85ZA)

* You can select "Separate" from the column menu of the column to separate, then select "Separate to Rows by ..." submenu, and select the separator.

### How to Use This Feature

![](/files/-M4oN9RtNuW180ivFHea)

1. Select column to separate from "Column to Separate" dropdown.
2. Specify separating text by selecting one from "Separate by" dropdown.
3. Specify parameters in the "Parameters" section.

* Guess column data type - The default is FALSE. Set TRUE to automatically guess the most possible data type for the columns in the result.

1. Click "Run".


---

# 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://docs.exploratory.io/data-wrangling/separate.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.