Generate Row with formula

[Devika]

Hello,

Please help me to generate a new row with the addition formula .

Row 2 + Row 4= Row5

Input 

My LE Name	My LE ID	Cpty LE Name	Nos
Devika		Nomura London	1
Devika		CREDIT SUISSE SECURITIES (EUROPE) LTD	2
Devika		Macquarie Bank Limited	3
Devika		Credit Suisse Securities(Europe)Limited	4
Devika		Svenska Handelsbanken AB (Publ)	5
Devika		National Bank Financial Inc.	6

Output 

My LE Name	My LE ID	Cpty LE Name	Nos
Devika		Nomura London	1
Devika		Macquarie Bank Limited	3
Devika		Svenska Handelsbanken AB (Publ)	5
Devika		National Bank Financial Inc.	6
Devika		CREDIT SUISSE SECURITIES	6

[IraWatt]

Hey @Devika 

What do you mean by adding rows? From looking at the data it seems row 2 and 4 have the same data and your output has combined them into one row?

Thanks,

Ira

[Devika]

Hello Ira,

i meant that i wanted to add the nos columns for the new row that gets generated . 

[IraWatt]

@Devika I'm not sure how you are generating these new row so its hard to say. Are you using a fuzzy match?

[rfoster7]

I think the point is that he doesn't know how to "group" the two values into one value because they are close but not identical, Otherwise a simple group by would work. I think you are right, you should be able to use fuzzy match logic to combine them, but I'm not familiar with the fuzzy match tool. Looking at the examples for it, there's one that seems like it does exactly what you are looking for. I would take a look at it

[binu_acs]

@Devika Are you looking something like this?