The Merge Matrix allows you to select which columns you would like to be merged together - and the order in which the original columns are to be added into the newly created column:



When you select these options, you will instantly see the additional column on the Data Preview window, as shown below:



Once you have created the Matrix for your dataset, you can then run the entire cleaning process by clicking the Run Clean button.


You can change how the words are separated using the Column merge separator which is located on the Clean Ribbon at the top of the application