Hi,

How / Is it possible to match entries in lists that are in a random order and are different lengths

i.e.

col1 col2
1 1
2 2
5 7
6 6
8 9
3 3
4 4
7
9

To get
col 1 col 2
1 1
2 2
3 3
4 4
5
6 5
7 6
8
9 9

Being in order isnt particuarly important but matching up the values is.

Thanks in advance.

Regards,
Steve