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 |
Hello,
Both are Credit Susie account so wanted to add the nos of it