1. Open your Google Sheet and locate the two columns you want to combine
In Google Sheets, identify the two columns you’d like to merge—like first and last names in columns A and B.
2. Select an empty column where the combined data will go
Click into the first empty cell in a new column (e.g., C2) to start merging the values from columns A and B.
3. Use the & operator to combine text
Type =A2 & " " & B2 to join the contents of A2 and B2 with a space in between. Adjust the formula for different separators (e.g., comma, dash).
4. Or use TEXTJOIN for more flexible merging
Use =TEXTJOIN(" ", TRUE, A2, B2) to combine cells with a chosen delimiter. TEXTJOIN automatically skips any empty cells.
5. Copy the formula down the column
Drag the fill handle down from the corner of the cell to apply the formula to the entire column and combine all row pairs.
6. (Optional) Convert formulas to static values
If needed, copy the combined column, then use Edit > Paste special > Paste values only to remove the formulas and keep just the text.
