Identifying repeat interaction from two columns

35 views Asked by At

I have two columns which contain investment bank names in joint debt offerings. I want to create a dummy variable if the Bank 1 & Bank 2 have recurring relationships.

Ex: if Lehman Brothers & Goldman Sachs or Goldman Sachs & Lehman Brothers appear in column 2 & 3, Dummy = 1

Can anyone suggest a method to calculate this relationship?

enter image description here

0

There are 0 answers