Hello dears

I having datas as follows(Example)

Sheet-1 Sheet-2
Col-A col-A Col-B
AA-01 AA-01 ABC-01
AA-02 CC-01 ABC-02
CC-01 AA-01 ABC-03

I want result like below in Sheet-1
Col-A Col-B Col-c
AA-01 ABC-01 ABC-03
AA-02
CC-01 ABC-02

Request you help on this.

Awaiting your help please

Regards
Peranish