“Combine Cell Contents” is an automation utility for combining contents of cells in multiple columns into a single column.
Separator The character to put between each component when being combined. It is like a “connector” between strings. Wrapper The character which is put in front and at the end of a string when being connected. For example, combined string can look like: ‘car’, ‘bus’, ‘plane’
This is especially useful in constructing SQL query statements, where string data type need to be “wrapped” in apostrophes.
Ignore-blank cells Blank cells are ignored. This is useful, for example, to avoid repeated separators or wrappers being placed. Reverse order Reverse the combine order, from right to left instead of left to right.