Sometimes it is useful to combine information from multiple columns into one using a process called “concatenation.” This method allows you to combine the contents of two columns, add a specific string to a column’s values, or a combination of both.
NOTE: This function requires the use of regular expressions. The relevant expressions are provided here, but for more information, please refer to the section on Google Refine Expression Language (GREL) and the Resources page.
value + cells[‘Column’].value
value + “-” + cells[‘Column’].value
5/2/2018 - Brinna Michael