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.