I have a data table which has only 1 instance of every observation but another data table which has multiple instances of the same observation in one column but diff values in other columns. I have attached the file for reference. merge 1 with multiple.xlsx (10.1 KB)

How do i merge two datatables which has 1 instance in 1 table and 3 instances in other data table

balupad14 (Balamurugan) March 12, 2018, 12:34pm 3

HI,
Can you check this. It may help you.

Regards
Balamurugan.S

1 Like

Topic		Replies	Views
How to Copy three Different Datatables into another datatable Help datatable , excel , activities , question	3	672	January 12, 2021
Merge more than two datable into one Help datatable , activities , question	5	1549	November 11, 2019
Merge Multiple Datatables Help datatable , activities , question , other	10	8849	March 13, 2024
Merge multiple data table where 1 column is common Activities datatable , excel	11	1515	August 12, 2023
How can I merge two data tables? Help	4	26908	April 4, 2019