Combines multiple columns into one column using a specified character
This step combines multiple columns into one column separated by a specified character.
Useful for creating lists inside of a single cell, which can help with transferring complex data, or creating lists to search against for avoiding duplicates.
Use the advanced settings to determine what character is placed between the combined columns, and set if you want that character to be inserted around blank cells. If you don't use that setting, blanks are essentially ignored.