I have two tables which doesn’t have a primary key. I want to merge them. I have attached a sample worksheet below. merge multiple.xlsx (10.1 KB)

Merge 2 tables without primary key

balupad14 (Balamurugan) March 7, 2018, 3:27pm 6

Hi ,
Here I have attached a sample for merge 2 tables without primarykey. I have written the output in Sheet4

Thank you
Balamurugan.S

2 Likes

Merge two datatables with common column

Compare rows from one excel to other excel

Topic		Replies	Views
Merging Data Tables Help datatable , excel , activities , question	10	2052	November 10, 2019
How do i merge two datatables which has 1 instance in 1 table and 3 instances in other data table Help datatable , activities	4	3556	September 14, 2018
Need help merging 2 data tables Activities datatable , question , system	10	1263	April 19, 2023
Compare rows from one excel to other excel Help excel	1	3184	March 12, 2018
Merge data Help	50	3387	August 24, 2019