You need to explain the rules as to why the source should transform to the
target coz it ain't obvious to me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cy" wrote in message
...
A B C A B
C
1 David 123 456 to David 789
000
2 789 000 CK 135
246
3 CK 135 246 CK 348
256
4 CK 348 256 Steve hij
kem
5 Steve abc efg
6 hij kem

Because i hv large amount of data,i don't want to copy and paste 1 by 1