Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to combine multiple columns into a single column, so:

one     four    seven
two     five    eight
three   six     nine


share|improve this question
That's not possible with plain old formula's. Have a look at this answer: webapps.stackexchange.com/a/39292/29140 – Jacob Jan Tuinstra Jun 4 '13 at 12:27
@JacobJanTuinstra Unfortunately that merges sheets, not columns. – 1ndivisible Jun 4 '13 at 12:53
It works for column ranges as well. – Jacob Jan Tuinstra Jun 4 '13 at 13:02
@JacobJanTuinstra since the answer to this and the other thread I cited above are the same should they be considered duplicates? (Great script find BTW) – batpigandme Jun 4 '13 at 13:18
up vote 4 down vote accepted

Install the VMERGE script from the script gallery:

screen shot

The script you just installed, makes it possible to combine multiple ranges into one: =VMERGE(range1,range2, ect)

See example file I've prepared for you to play with: VMERGE and Ranges

share|improve this answer
Beautiful. Much obliged. – 1ndivisible Jun 4 '13 at 13:57
At this time the Script Gallery is available only for old spreadsheets that had not being migrated yet. – Rubén May 3 '15 at 0:44
Yeah; no more VMERGE still. – Jason C Jul 18 '15 at 9:13

The following formula can be used to merge one column after another:

={A1:A5; M1:M5}
share|improve this answer
+1 The principle works well for me, though something like ={A1:A3;B1:B3;C1:C3} might have been more in keeping with the OP. – pnuts Oct 14 '14 at 19:04

In the new Google Spreadsheets, the script gallery has been replaced with the add-on store.

You can try this function to combine two columns


Please check this link for detail

share|improve this answer
OP mentions multiple columns and illustrates three, can this formula be adapted for three separate columns as inputs, or are you suggesting a two-step process? – pnuts May 1 '14 at 18:02

Here is my answer from Stack Overflow:

The unique() function gets rid of blank spaces, but wasn't helpful for me because some of my rows repeat. Instead I first filter the columns by len() to remove blank cells. Then I combine the columns together in the same way.

={filter(sheetone!A:A, len(sheetone!A:A)); filter(sheettwo!A:A, len(sheettwo!A:A))}
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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