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