Thank for you reply but It needs to be re-arrange and sort based on the left column, like table below: IF 16YcK36 this is in the first row, then cK36 must on that row as well, because the data at 2nd column it goes in random and not sorted according to the last 3 string of column 1. ref1_tobe toref1_tobe 16YcK36 cK36 20Sdj60 dj60 13Nbc46 bc46 15Nfg64 fg64 13Tnf32 nf32
... View more