0

This question already has an answer here:

For example columns are setup as:

A | B
-----
1 | a
2 | b
3 | c
4 | d
5 | e

I want to be able to make column C be like this:

 C
---
 1
 2
 3
 4
 5
 a
 b
 c
 d
 e

via formula. The two columns will actually be in different sheets and both will be updated over time. I don’t really care about order but I am not sure how to get this to happen.

marked as duplicate by Jacob Jan Tuinstra, John C, ChrisF Jun 16 '13 at 10:13

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.

0

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

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