Sorry I have just work out the way of doing that.

Another question is for a row of repeatted test / numbers, how could I
summarize them into a catelogue, e.g. transfer from A column to B column

A B
Sue Fred
Fred Richard
Richard Sue
Sue
Richard
....

No macros either. Thanks a lot.