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.