Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
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
    
@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
show 1 more comment

2 Answers

up vote 5 down vote accepted

Install the VMERGE script from the script gallary:

enter image description here

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
add comment

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
2  
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 at 18:02
add comment

Your Answer

 
discard

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.