I have two columns [first name] [last name]

I need to merge them to one column to see [first name last name]

  • 1
    Do you need to actually merge the data, or do you just want to display the data in a single column? – ale Dec 14 '13 at 15:54

If you don't want to actually merge the data, but want to display it together in a third column, just use the string concatenation operator &.

=A1 & " " & B1

That displays the text in cell A1, followed by a space, then the text in cell B1.

(If you just want to mush the values from two cells together, use the CONCAT() function.)

  • CONCAT and the method you used are the same thing. You could use '=A1&B1' which would be the same as '=CONCAT(A1,B1)'. Or your answer of '=A1 & " " & B1' would be the same as '=CONCAT(A1," ",B1)' – guitarthrower Dec 17 '13 at 23:56
  • 1
    @gui: I thought CONCAT could only take two parameters? – ale Dec 18 '13 at 0:24
  • well look at that. Excel's version will take many, but not google's. Thanks for the clarification. For simplicity, even if it is just 2 parameters I will generally not use the CONCAT function, I'll simply use &. (personal preference!) – guitarthrower Dec 18 '13 at 0:40

You can use VMERGE:

Yogi Anand:

The VMERGE custom written function written by ahab available from Script Gallery to use VMERGE you have to first install it in the spreadsheet of interest where VMERGE is to be used

To install VMERGE:
1) click on Tools > Script gallery
2) search for VMERGE
3) once found click on Install once the function is installed in your spreadsheet you can use it like any other spreadsheet function without any further entaglement with Google Apps Script

  • Hi, trying this, but don't see Script gallery on menu. Is it still actual with current version of Google Sheets? – Kostanos Jul 4 '16 at 2:56
  • 1
    @Kostanos no idea, Google UI keeps changing… – Franck Dernoncourt Jul 4 '16 at 3:06

Not the answer you're looking for? Browse other questions tagged or ask your own question.