How to merge two datatable and list common and uncommon values?

I have 2 excel sheets with different datarows in it.There is one coloum common to both tables but it has redundant values.I need to produce output in third data table as per below from both tables.Common values from both table should be listed once.Can anyone explain logic for below?

dt1 dt2 dt3
c1 c2 c1 c2
101 fsd 101 fsd
101 sss 101 bb
102 aaa 102 qq
102 qqq
102 ccc

dt3 should be like below:

c1 c2
101 fsd
101 sss
101 bb

Hi @rahul_kumar4
do u need common values from both datatables ?

yes it should be there and the values which are not common should also populate

Hi @rahul_kumar4
i got confused

can u explain with a good example?

@rahul_kumar4
find starter help here:
Find_Common_NonCommon2_By1Col.xaml (13.4 KB)

1 Like