Add a Row with Formula

[Devika]

tips Hello All,

Please help me to add a two rows below highlighted (CREDIT SUISSE ) and give me one row

Input 

My LE Name	My LE ID	Cpty LE Name	Cpty LE ID
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	Cpty LE ID
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(Europe)Limited (871) CT Profile (10740)	6

[flying008]

Hi,@Devika 

1- what is your logic for add rows ?

2-  ' (871) ' & ' CT Profile (10740)  ' is from where? 

[Devika]

Hello,

Both are Credit Susie account so wanted to add the nos of it