Hi team, can someone please help me transforming data like below:
Input
| ABC-DL 12345 ABC BANK, LLC A/C 12345B817413 |
| DEL BR 00123 12345 ABC BANK, LLC A/C | |
| DDA CONTROL# 123456789 PET LOP/FEE |
| TRADE DATE 12/01/2022 SETTLE DATE 01/12/2023 ISSUE DATE |
| CUSIP/VER 01E062794 SECTYPE/CORPORATE-DEBT DAYS INTEREST |
| URF-FV 57,000,000.00000 | |
| PRICE IN USD 102.63125 | |
| PRINCIPAL 57,413,742.5 | |
| NET AMT 57,413,742.5 | |
I want the above data to be transformed like below output. Thanks.
Output (Position of the columns don't matter)
| ABC-DL | A/C | DEL BR | DDA CONTROL# | TRADE DATE | SETTLE DATE | CUSIP/VER | URF-FV | PRICE IN USD | PRINCIPAL | NET AMT |
| 12345 ABC BANK, LLC | 12345B817413 | 00123 ABC BANK, LLC | 123456789 | 12/01/2022 | 01/12/2023 | 01E062794 | 57,000,000.00 | 102.63125 | 57,413,742.50 | 57,413,742.50 |
