How to combine two dynamic arrays to make one dynamic array in a formula?

Question

I have two columns both with results of individual unique functions, i.e. both columns contain unrelated dynamic arrays. Is there a way I can combine both these dynamic arrays as a single dynamic 2D array and use in a formula?

Example:

Cell A1 = UNIQUE(rng1) Cell B1 = UNIQUE(rng2)

both always return same number of items.

What I want in cell D1 = SORT(A1#:B1#) --> how do I do this combination?

The notation A1#:B1# gives an error.

Answer 1

You could use:

=SORT(CHOOSE({1,2},A1#,B1#))