Merge
The Merge matrix will allow you to join values (must be text values) from multiple columns and place them into a newly created column. For example, on a list that contains the fields "Firstname" and "Surname" with the values "John" and "Smith", this may be concatenated to give "John Smith" in a separate column.
Click the following option to learn more:
Column merge separator