I am having two excel sheets containing 3 columns each where two columns of each file have some common rows.
I want to generate a new excel where 1 excel remains as it is and 2 excel column matches and enters into 1 or the uncommon column is added at last.
If condition matches then column gets added otherwise a new row gets added into the excel.
The excel file is Groupby and match.xlsx (10.2 KB) where Sheet1 and Sheet2 are two sheets and Output shows the required output
The output should be like