View Single Post
  #1   Report Post  
Max
 
Posts: n/a
Default Sorting two columns of data

Hi,
I have two columns of numbers, that I need to sort into one column.
They are not sequential and some of the same numbers appear in each column.
In the resulting column I need all the numbers listed in ascending order
without duplication. The first column will range from 1 to 120 but not with
all the numbers in the list from 1 to 120. (some numbers will be missing).
The second column may have duplications of the first column, but with some
unique numbers. eg (short list)

1 1
5 5
13 16
16 19
19 34
21 37
24 49
29 50
33 51
36 54
37 60
39 72
40 85
42 102
50
51
54
60
61
65
66
69
70
How can I sort these using functions.