Merging Columns
Merge multiple columns in your transform, use a delimiter in your merge, assign a new name to the resulting column, and add a prefix or suffix to the contents of the column.
To merge columns:
The transform displays a new merge column with the name that you assigned to it and the contents from the available columns that you selected for the merge.