Hello,
I need help to combine columns from two excel files to one.
I basically need to validates the data for example:
Amount contains some data from Excel 1
Amount 2 contains data from Excel 2
I need output as below. without have nulls row/Extra rows.
And At last I need a message output : the rows are matched for Amount and Amount 2.
If not matched then : Rows are not matched.
| Amount | Amount 2 |
| 100 | 100 |
| 100,10 | 100,10 |