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