I need a VBA code that check column A and B and if find the same data as you see in the below images combine and merge them in one row in sheet 2 and delete the rows that combined in sheet1



Sheet1 : Before Run VBA



Sheet2 : After run VBA




Sheet1 : when deleted the data on sheet1


Thank you very much.