Developer Forum

Hello,

By matching two column I want to add the third column, but only the desire
model


Model Size (mm) QTY
JE-122 50 2
JE-123 80 2
JE-124 100 3
JE-125 150 4
JE-122 50 1


Expected Result:

Model Size (mm) QTY
JE-122 50 3


Can some one help me in this regard???

Hello,

By matching two column I want to add the third column, but only the desire
model

Column 1= Model
Column 2= Size
Column 3= Qty

Column 1
JE-122
JE-123
JE-124
JE-125
JE-122

Column 2
50
80
100
150
50

Column 3
2
2
3
4
1


After Matching Column 1 and Column 2 the result should be as follows:

For Model JE-122 and size 50 Total Qty=3

and vise versa..



Can some one help me in this regard???