Combine Columnsis used to merge two columns into one.

If the CSV table is

Combining the columns 1 and 2 results in

To useCombine Columns, select the columns that you want to combine and go toCSV > Columns > Combine Columns….

TheUse first non-empty value option will combine columns by taking the left-most non-empty value for each row.Here is a case where this was useful.

Split Columnsis the inverse command which splits a column with the given separator. It is underCSV > Columns > Split Columns….