Merge and Combine Columns

Select columns containing first name (e.g., column 1) and last name (column 2), choose space as the separator, and merge. "John" + "Doe" becomes "John Doe". You can keep or remove the original separate columns.

Yes, merge any number of columns. Combining columns 1, 2, 3, and 4 with comma separators creates a single value from all four. Useful for addresses, composite identifiers, and multi-part data.

You can configure empty value handling: skip empty values (avoiding double separators), include them as empty strings, or replace them with a placeholder. This ensures clean results with incomplete data.

Yes, use format templates like "{1} ({2})" to add static text around merged values. This turns "Sales" + "NY" into "Sales (NY)". Templates provide precise control over the combined format.

Yes, choose to either preserve original columns (adding a new merged column) or replace them (removing source columns and keeping only the combined result). Both options are available based on your needs.