Combine datatable rows based in common value

[pipelian]

Hi,
i have been trying to combine data from 2 different sources, to make unique rows: here it is my situation
Data in DGV already in dgv, Unbound:

column1 | Qty
"Sugar", 100
"Salt", 100
"Color", 200
"Malto", 150

Data in datatable:

column1 | Qty
"Sugar", 80
"Salt", 60


"Apio", 25
"Lemon", 60
"Color", 60

So i want a control that matches the column1 in datatable against DGV.Column1, and if value matches only add second column value and if not, then make a new row in DGV.
Final decided outcome:

column1 | Qty|Qty2
"Sugar"| 100 | 80
"Salt" | 100 | 60
"Color"| 200 | 60
"Malto"| 150
"Apio" | | 25
Thanks In Advance

[orange]

I suggest you research Normalization to get the proper table design.
This site may be helpful http://phlonx.com/resources/nf3/