Hi,

I have two sets of data from two sources and they should match, rows numbers and row content. Each row only has two columns.


My problem is that the source systems have come out of sync and I need to identify the discrepancies.

The format is exampled below and will run into hundreds of lines in each file.

AA11BB11 JOAN1
AB77GG88 JOHN28
BS54SB77 JACK00


My thought was to copy one set of data and add to columns C and D, then do something clever which would align the two sets of data (first set in A,B the second in C,D columns).

AA11BB11 JOAN1 AA11BB11 JOAN1
AB77GG88 JOHN28 BS54SB77 JACK00
BS54SB77 JACK00 DE89SS88 JIMAB
DE89SS88 JIMAB AN32RU88 WAAV2F
AN32RU88 WAAV2F AN78UA40 MACKAR
AN78UA40 MACKAR AN95LA92 VUEBAL
AN95LA92 VUEBAL


My short fall is the clever bit. Any good ideas?


Thanks, Neil