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

This question already has an answer here:

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

one     four    seven
two     five    eight
three   six     nine

Becomes:

one
two
three
four
five
six
seven
eight
nine
share|improve this question

marked as duplicate by Rubén, sandwich, Al E., jonsca Mar 7 at 0:20

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1  
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
1  
    
@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
1  
Update: See this answer, the accepted one is for the old version of Sheets. – sandwich Mar 6 at 16:53
up vote 3 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
1  
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  
+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

If the columns are A, E, G (for example), then the following command combines them:

={filter(A:A, len(A:A)); filter(E:E, len(E:E)); filter(G:G, len(G:G))}

Here, I first filter the columns by len() to remove blank cells. Then I combine the columns together.

An example combining columns in different sheets:

={filter(sheetone!A:A, len(sheetone!A:A)); filter(sheettwo!A:A, len(sheettwo!A:A))}

Adapted from my answer from Stack Overflow.

share|improve this answer

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

=unique(transpose(split(join(";",A:A)&join(";",B:B),";")))

Please check this link for detail

share|improve this answer
3  
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

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