Excel 1 with 4 columns ( A B C D ) : The column D & C are empty fields
Excel 2 with 4 columns but have ( A E F G ) for example.
The “A” is the column in commun between the two datatables.
I want my bot to read the two datatables, and then enter in column “D” the values of column “G” when the data in column “A” is matching. if the column “G” is empty, enter in column “C” the values of column “F”
Thank you in advance!