Merge 2 different Excel In 1st excel

Help Studio
, ,
5

This is a spreadsheet containing invoice details for various suppliers, including columns for Invoice ID, due dates, purchase dates, sales order dates, organization names, and amounts in Euro. (Captioned by AI)
This is a spreadsheet containing invoice details for various suppliers, including columns for Invoice ID, due dates, purchase dates, sales order dates, organization names, and amounts in Euro. (Captioned by AI)1415×362 15.9 KB

Your output look like this but i wan to add the dt2 from last column and copy the dt1 value to rest of the rows