Merge Two Columns

Align the two source columns before merging so each pair belongs together.

Paired Column Merger

1. Paste the left-hand values into Insert list and the right-hand values into Insert second list, with one value per row.
2. Select Add space when paired values need a separating space. Transform to lowercase changes the second value in each pair while preserving the first value.
3. Click Merge to process the current input.
4. Read Result for paired rows and Rows remaining without a pair for the excess rows from the longer input. Merged rows and No pair summarize those counts.
5. Click Copy under the output you want to keep. Use Clear where shown to clear the text fields; option selections stay as set.

With Fresh and Sweet in the first list and APPLES in the second, select Add space and Transform to lowercase. Result is Fresh apples; Sweet remains without a pair.

Pairing follows the original positions

One output row is created for each available pair. This does not generate every possible combination. Preserve row alignment when values refer to related records.

Check separators before copying

Without Add space, values are joined directly. Existing spaces in a source value are preserved, so inspect the result if your copied columns already contain padding.