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 |