Generate Row with formula

Question

Hello,

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

Row 2 + Row 4= Row5

Input

My LE NameMy LE IDCpty LE NameNosDevika  Nomura London1Devika  CREDIT SUISSE SECURITIES (EUROPE) LTD2Devika  Macquarie Bank Limited3Devika  Credit Suisse Securities(Europe)Limited4Devika  Svenska Handelsbanken AB (Publ)5Devika  National Bank Financial Inc.6

Output

My LE NameMy LE IDCpty LE NameNosDevika  Nomura London1Devika  Macquarie Bank Limited3Devika  Svenska Handelsbanken AB (Publ)5Devika  National Bank Financial Inc.6Devika  CREDIT SUISSE SECURITIES 6

binu_acs · Answer

@Devika Are you looking something like this?

Fuzzymatch_11_05.yxmd

rfoster7 · Answer

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

IraWatt · Answer

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