Merge Excel cells in Faster way

[AshwinS2 (Ashwin S)]

Hi @anjalimishra
Please do see the below post

Search for column value and merge data cells

I have two excel sheets where one has duplicate ids with 1 more column and the other has only unique ids with 1 extra column. I want to merge them by searching for those unique ids from the second datatable in the first datatable. I have uploaded a sample file for better understanding.merge.xlsx (9.8 KB)

Thanks
Ashwin S