Spreadsheet: 860181d1708380966-power-query-extracting-from-multiple-columns-into-a-new-column-transaction-detail-report-sample-dj
Sheet: Desired Results

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