0

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.

Improve this question
0
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

Improve this answer
0

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