How do you match one column's numbers with the 2nd column?

[lnsykalski]

How do you math one column's numbers with the 2nd column?

Like if you had:

1 2
2 3
3 6
4
5
6
7

... and you wanted it sorted like so
2 2
3 3
6 6
1
4
5
7

Any idea how to do that?

Thanks,
Lee:confused

 

[Ardus Petus]

Assuming your data are in columns A and B

insert a staging column before column B, with following formula:
=IF(ISNA(MATCH(A1,C:C,0)),"",MATCH(A1,C:C,0))

Select columns A:B
Data>Sort by Column B (ascending)

HTH