excelsorting

How to do a union of two columns and then sort them into a third column in Excel?

I'm having the following sorting problem in excel - I have two columns which are sorted and could potentially have some identical values. I want to take the union of the two columns (e.g. A = {x,y,z}, B = {a,b,c}; C = A U B = {a,b,c,x,y,z}) and then sort them (as seen in the prior example).

Here's how it should look like in excel -

enter image description here

I haven't seen anything on Google or Stack Overflow that has a solution for this problem. What formula can I use to get the above result?

Solution

  • In the first row put

    =SMALL($A$1:$B$10,ROW(1:1))

    then copy down.

    Non duplicate solution to be added