Spreadsheet: 860197d1708396773-power-query-extracting-from-multiple-columns-into-a-new-column-transaction-detail-report-sample-dj
Sheet: Table1

Transaction Date | ORIG CO NAME | Account Name | Account Number | Transaction Type | Amount | Transaction Number | Bank Reference
2024-02-08 00:00:00 | 36 TREAS 310 | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 3335.93 |  | 1234567899TC
2024-02-08 00:00:00 | STATE OF MARYLAN | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 33739.6 | *1*2* | 1234567899TC
2024-02-07 00:00:00 | BCBS ILLINOIS | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 436.08 | *1*C2* | 1234567899TC
2024-02-05 00:00:00 | FIDELIS CARE | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 26872.04 | *1*2* | 1234567899TC
2024-02-07 00:00:00 | AETNA AS01 | ACCOUNT NAME 2 | XXXXXXXX2 | EFT CREDIT | 8593.58 | *1*2* | 1234567899TC
2024-02-09 00:00:00 | Testt Company AB | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 539.98 | *1*CM*NetOf110200Minus56202* | 1234567899TC
2024-02-07 00:00:00 | [NAME] | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 1860 | *1*2* | 1234567899TC
2024-02-06 00:00:00 | AETNA A04 | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 6202.8 | *1*2* | 1234567899TC
2024-02-09 00:00:00 | CIGNA | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 5538 | *1*2* | 1234567899TC
2024-02-09 00:00:00 | InstaMed | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1917.13 |  | 1234567899TC
2024-02-09 00:00:00 | HEALTHFIRST PHSP | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 441.72 | *1*3* | 1234567899TC
2024-02-09 00:00:00 | Amerigroup GA5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1089.36 | *1*3* | 1234567899TC
2024-02-09 00:00:00 | BLUE CROSS GA5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 4699.88 | *1*3* | 1234567899TC
2024-02-09 00:00:00 | ANTHEM BLUE VA5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 202.75 | *1*3* | 1234567899TC
2024-02-09 00:00:00 | VERA-FUND LLC | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 33270.43 |  | 1234567899TC
2024-02-09 00:00:00 | CIGNA EDGE TRANS | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 15786.2 | *1*XXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | MVP HEALTH PLAN | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 740 | *1*XXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | National Grid | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 426 | *1*XXXXXXXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | HUMANA GOVT BUSI | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2792.08 | *1*XXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | LOYALEHLTH SV9T | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 6817.15 |  | 1234567899TC
2024-02-09 00:00:00 | Testt Company Li | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 920.68 | *1*UH123456789XXXXXXXXXXX*NetOf187894Minus95826* | 1234567899TC
2024-02-09 00:00:00 | HNB - ECHO | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 8269.2 | *1*XXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | UNITED BEHAVIORA | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 5038.44 | *1*XXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | VSHP VOL II FUND | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2937.62 | *1*XXXXXXXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | UMR | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 958.35 | *1*CE1234567890XXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | UMR State of Nev | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 219.43 | *1*CE1234567890XXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | VSHP TN CARE SEL | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 360.61 | *1*XXXXXXXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | CIGNA HLTH LIFE | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2012 | *1*XXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | OXFORD HEALTH IN | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 293.24 | *1*XXXXXXXXXX* | 1234567899TC
2024-02-08 00:00:00 | Wellpoint TN5C | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1052.8 | *1*XXXXXXXXXX* | 1234567899TC
2024-02-08 00:00:00 | UNITEDHEALTHCARE | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 732.7 | *1*1TZXXXXXXXX* | 1234567899TC
2024-02-08 00:00:00 | BCBST OF TN | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 15855.14 | *1*XXXXXXXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-08 00:00:00 | BCBST FEP BASIC | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2042.5 | *1*XXXXXXXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-08 00:00:00 | ACH MEDICAID | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 12354.99 | *1*XXXXXXXXXX* | 1234567899TC
2024-02-05 00:00:00 |  | ACCOUNT NAME 5 | XXXXXXXX5 | CHECK | -75 |  | [PHONE]
2024-02-05 00:00:00 |  | ACCOUNT NAME 5 | XXXXXXXX5 | CHECK | -25 |  | [PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | -201.32 |  | [PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | -101.29 |  | [PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | -105.89 |  | [PHONE]
2024-02-09 00:00:00 |  | ACCOUNT NAME 6 | XXXXXXXX6 | CHECK | -233.2 |  | [PHONE]
2024-02-08 00:00:00 | KAISER FOUNDATIO | ACCOUNT NAME 7 | XXXXXXXX7 | EFT CREDIT | 23327 | *1*XXXXXXXXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | [PHONE] | ACCOUNT NAME 8 | XXXXXXXX8 | EFT CREDIT | 283.34 | *1*XXXXXXXXXX* | 1234567899TC
2024-02-09 00:00:00 | HORIZON | ACCOUNT NAME 8 | XXXXXXXX8 | EFT CREDIT | 40690.05 | *1*XXXXXXXXXX* | 1234567899TC