You can combine two lists and add a prefix, a suffix, and a separator that you choose. This is helpful when you want to join or merge two text documents line by line.
Concatenate first names and surnames, with
space as a separator.
Sarah Anthony William StevenColumn 2
Mitchell Edwards Johnson DavisResult
Sarah Mitchell Anthony Edwards William Johnson Steven Davis
Exclude Empty Lines
When this option is turned on, the tool won't add the prefix, suffix, or separator you've chosen when both lines are empty.
- Split Text - Split a text into individual columns, or by a new line.
- Extract Column - Get a specific column from a delimited text.
- Swap Columns - Swap two columns from a delimited text.