How to combine two columns?

[Gaurav0001]

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

100

100,10

Amount 2 contains data from Excel 2

Amount 2

100,10

100

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

[aatalai · Accepted solution]

@Gaurav0001 use the join tool, attached an example below

[aatalai]

@Gaurav0001 if this works can you mark it as a solution

[Gaurav0001]

Thank You @aatalai