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.