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?