How to copy entire row in one excel and paste in to excel

Hello @Baby123

Please check the below video. You can compare the two datatable and get the similar and disimilar rows and then merge both.