Combine & Sort Data from 2 or more columns into 1

[hro5e]

I have 2 columns each will unique data.

1st column has 25 data entries.

2nd column has 13 data entries.

How do I combine the data so that in the 3rd column will have all 38 data entries.

The data must be sorted alphabetically automatically, so using formulas.

-

I need the formula for the above, plus a separate formula that will remove duplicates.

-

I look forward to your help

 

[oldbrewer]

7	9
4	2
9	3
15	2
7	3
6	18
4	1
	1
	8			row 9
				name A1 to B9 as myrange
				then use large function to sort them lower col A
				then use a formula to put a blank if say B16=C15 lower col B
				finally use large again to list in order
1	18	18	18
2	15	15	15
3	9	9	9
4	9		8
5	8	8	7
6	7	7	6
7	7		4
8	6	6	3
9	4	4	2
10	4		1
11	3	3
12	3
13	2	2
14	2
15	1	1
16	1
17
18
19
20

<colgroup><col width="64" span="11" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[oldbrewer]

correction first lower column is just a rising index number

 

[hro5e]

Hi,

There are no formulas?

 

[oldbrewer]

name A1 to B9 as myrange
				then use large function to sort them lower col A -- in B15 put =large(myrange,a15)
				then use a formula to put a blank if say B16=C15 lower col B clearly C15 = B15 in C16 put =if(B16=C15,"",B16) name c15 to c50 myrange2 then in D15 down =large(myrange2,c15)
				to avoid errors use =if(iserror(yourfomula here),"",yor formula here)

<tbody>
</tbody>