Join Columns

Key Features

• Flexible column selection – Choose any two columns to join by index.
• Custom separator – Insert a string between the joined values (e.g. a space, comma, or “-”).
• Row range control – Specify the starting row. The join will apply from that row to the end of the dataset.
• Appends new column – The joined values are added as a new column at the end of each row; original columns remain unchanged.

How to Use

1. Open the Join Columns dialog.
2. Enter the Start Row (row index where joining should begin).
3. Select the First Column and Second Column to join.
4. Optionally, enter a Separator (e.g. space, comma, underscore).
5. Click Apply – a new column with the joined values will be added to your dataset.

Example

Original dataset

First | Last   | Age
------|--------|----
John  | Smith  | 30
Jane  | Doe    | 25

Join settings
First Column: 0 (First)
Second Column: 1 (Last)
Separator: " "

Resulting dataset

First | Last   | Age | Joined
------|--------|-----|--------
John  | Smith  | 30  | John Smith
Jane  | Doe    | 25  | Jane Doe