Select the cells you want to merge
Go to the Home tab
Click Merge & Center in the Alignment group
Choose Merge Cells if you do not want centered text
Use CONCAT or TEXTJOIN formulas to combine data from multiple columns
Example: =A1&” “&B1
Example: =TEXTJOIN(” “,TRUE,A1:C1)
Copy the formula down for all rows
If needed, copy the results and paste as values
Use Flash Fill by typing the desired combined result and pressing Ctrl+E
Use Power Query to combine columns for larger datasets
