Spreadsheet: 860042d1708275665-power-query-extracting-from-multiple-columns-into-a-new-column-transaction-detail-report-sample
Sheet: Details

Transaction Date | Account Name | Account Number | Description | Amount | Cr/Dr | Transaction Type | Credit Amount | Debit Amount | Customer Reference | Bank Reference | REMARK 01 | REMARK 02 | REMARK 03 | REMARK 04 | REMARK 05 | REMARK 06 | REMARK 07 | REMARK 08 | REMARK 09 | REMARK 10 | REMARK 11 | REMARK 12 | REMARK 13 | REMARK 14 | REMARK 15
2024-02-08 00:00:00 | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 3335.93 | CR | ACH | 3335.93 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240208 | IND ID NO=XXXXXXXXXX | ORIG CO NAME=36 TREAS 310 | ORIG BANK=[NAME] | ORIG ID=XXXXXXXX | DESC DATE=020824 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CTX | ENTRY DESCR=MISC PAY
2024-02-08 00:00:00 | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 33739.6 | CR | ACH | 33739.6 |  | TEXT | 1234567899TC | ENTRY DATE=240208 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=STATE OF MARYLAN | ORIG BANK=MARYLAND NATIONAL BANK | ORIG ID=NXXXXXXXX | DESC DATE=240206 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-07 00:00:00 | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 436.08 | CR | ACH | 436.08 |  | C123456789 | 1234567899TC | ENTRY DATE=240207 | IND ID NO=C123456789 | REMARK=TRN*1*CXXXXXXXXXXXXXX* | ORIG CO NAME=BCBS ILLINOIS | COMPANY DATA=PAYABLE | ORIG BANK=NORTHERN TRUST CO | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-05 00:00:00 | ACCOUNT NAME 1 | XXXXXXXX1 | EFT CREDIT | 26872.04 | CR | ACH | 26872.04 |  | 123456789 | 1234567899TC | ENTRY DATE=240205 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=FIDELIS CARE | ORIG BANK=MARINE MIDLAND BANK | ORIG ID=XXXXXXXX | DESC DATE=240130 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-07 00:00:00 | ACCOUNT NAME 2 | XXXXXXXX2 | EFT CREDIT | 8593.58 | CR | ACH | 8593.58 |  | 123456789 | 1234567899TC | ENTRY DATE=240207 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=AETNA AS01 | ORIG BANK=Bank of America | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 539.98 | CR | ACH | 539.98 |  | S1D0XXX7YXRXWXS | 1234567899TC | ENTRY DATE=240209 | IND ID NO=S1D0XXX7YXRXWXS | REMARK=TRN*1*CMXXXXXXXXXXXXXXXX*NetOf110200Minus56202* | ORIG CO NAME=Testt Company AB | ORIG BANK=GOLDMAN SACHS BANK USA | ORIG ID=GSXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=NETSWEEP
2024-02-07 00:00:00 | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 1860 | CR | ACH | 1860 |  | [NAME] | 1234567899TC | ENTRY DATE=240207 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=[NAME] | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=IXXXXXXXX | DESC DATE=240206 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-06 00:00:00 | ACCOUNT NAME 3 | XXXXXXXX3 | EFT CREDIT | 6202.8 | CR | ACH | 6202.8 |  | XXXXXXXXXX | 1234567899TC | ENTRY DATE=240206 | IND ID NO=XXXXXXXXXX | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=AETNA [NAME] | ORIG BANK=CITIBANK | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 5538 | CR | ACH | 5538 |  | XXXXXXXXXX | 1234567899TC | ENTRY DATE=240209 | IND ID NO=XXXXXXXXXX | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=CIGNA | ORIG BANK=WELLS FARGO BANK NA | ORIG ID=XXXXXXXX | DESC DATE=020624 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1917.13 | CR | ACH | 1917.13 |  | XXXXXXXXXX | 1234567899TC | ENTRY DATE=240209 | IND ID NO=XXXXXXXXXX | ORIG CO NAME=InstaMed | ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=PROUD MARYS
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 441.72 | CR | ACH | 441.72 |  | [NAME] | 1234567899TC | ENTRY DATE=240209 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=HEALTHFIRST PHSP | COMPANY DATA=HEALTHFIRST HIX | ORIG BANK=21127445 | ORIG ID=XXXXXXXX | DESC DATE=240207 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1089.36 | CR | ACH | 1089.36 |  | 987654321 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=987654321 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=Amerigroup GA5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 4699.88 | CR | ACH | 4699.88 |  | 987654321 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=987654321 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=BLUE CROSS GA5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=AXXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 202.75 | CR | ACH | 202.75 |  | 987654321 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=987654321 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=ANTHEM BLUE VA5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 33270.43 | CR | ACH | 33270.43 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789101112 | ORIG CO NAME=VERA-FUND LLC | COMPANY DATA=COF00000000009141248 | ORIG BANK=BANK OF NEW YORK MELLON | ORIG ID=XXXXXXXX | DESC DATE=240208 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=COF CREDIT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 15786.2 | CR | ACH | 15786.2 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789101112 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=CIGNA EDGE TRANS | COMPANY DATA=HCCLAIMPMT | ORIG BANK=24207175 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 740 | CR | ACH | 740 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=MVP HEALTH PLAN | ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK | ORIG ID=XXXXXXXX | DESC DATE=240207 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 426 | CR | ACH | 426 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* | ORIG CO NAME=National Grid | ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK | ORIG ID=XXXXXXXX | DESC DATE=240207 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2792.08 | CR | ACH | 2792.08 |  | 12345678910 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=[PHONE] | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=HUMANA GOVT BUSI | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | DESC DATE=020724 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 6817.15 | CR | ACH | 6817.15 |  | [NAME] XXX | 1234567899TC | ENTRY DATE=240209 | ORIG CO NAME=LOYALEHLTH SV9T | COMPANY DATA=[NAME] | ORIG BANK=24207175 | ORIG ID=XXXXXXXX | DESC DATE=240208 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=PPD | ENTRY DESCR=XXXXXXXX
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 920.68 | CR | ACH | 920.68 |  | AXR1QXQXX3XXRXY | 1234567899TC | ENTRY DATE=240209 | IND ID NO=AXR1QXQXX3XXRXY | REMARK=TRN*1*UH123456789XXXXXXXXXXX*NetOf187894Minus95826* | ORIG CO NAME=Testt Company Li | ORIG BANK=GOLDMAN SACHS BANK USA | ORIG ID=GSXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=NETSWEEP
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 8269.2 | CR | ACH | 8269.2 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=HNB - ECHO | ORIG BANK=[NAME] | ORIG ID=XXXXXXXX | DESC DATE=240209 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 5038.44 | CR | ACH | 5038.44 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=UNITED BEHAVIORA | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2937.62 | CR | ACH | 2937.62 |  | 1234567 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=1234567 | REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* | ORIG CO NAME=VSHP VOL II FUND | COMPANY DATA=CLAIM PYMT | ORIG BANK=First Horizon Bank | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 958.35 | CR | ACH | 958.35 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789 | REMARK=TRN*1*CE1234567890XXXXXXXXXXXXX* | ORIG CO NAME=UMR | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 219.43 | CR | ACH | 219.43 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789 | REMARK=TRN*1*CE1234567890XXXXXXXXXXXXX* | ORIG CO NAME=UMR State of Nev | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 360.61 | CR | ACH | 360.61 |  | 1234567 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=1234567 | REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* | ORIG CO NAME=VSHP TN CARE SEL | COMPANY DATA=CLAIM PYMT | ORIG BANK=First Horizon Bank | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2012 | CR | ACH | 2012 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789101112 | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=CIGNA HLTH LIFE | ORIG BANK=CITIBANK | ORIG ID=XXXXXXXX | DESC DATE=240209 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 293.24 | CR | ACH | 293.24 |  | 123456789 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=OXFORD HEALTH IN | ORIG BANK=PNC BANK | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-08 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 1052.8 | CR | ACH | 1052.8 |  | 123456789101112 | 1234567899TC | ENTRY DATE=240208 | IND ID NO=123456789101112 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=Wellpoint TN5C | COMPANY DATA=EDI PAYMENT | ORIG BANK=BANK OF AMERICA, N.A. | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-08 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 732.7 | CR | ACH | 732.7 |  | 123456789 | 1234567899TC | ENTRY DATE=240208 | IND ID NO=123456789 | REMARK=TRN*1*1TZXXXXXXXX* | ORIG CO NAME=UNITEDHEALTHCARE | ORIG BANK=12438487 | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-08 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 15855.14 | CR | ACH | 15855.14 |  | 1234567 | 1234567899TC | ENTRY DATE=240208 | IND ID NO=1234567 | REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* | ORIG CO NAME=BCBST OF TN | COMPANY DATA=CLAIM PYMT | ORIG BANK=First Horizon Bank | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-08 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 2042.5 | CR | ACH | 2042.5 |  | 1234567 | 1234567899TC | ENTRY DATE=240208 | IND ID NO=1234567 | REMARK=TRN*1*XXXXXXXXXXXXXXXXXXXXX* | ORIG CO NAME=BCBST FEP BASIC | COMPANY DATA=MEDICAL - FEB | ORIG BANK=FIRST NATL BK OF BIRMINGHAM | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-08 00:00:00 | ACCOUNT [NAME] 4 | [NAME] | EFT CREDIT | 12354.99 | CR | ACH | 12354.99 |  | 123456789 | 1234567899TC | ENTRY DATE=240208 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=ACH MEDICAID | ORIG BANK=JPMORGAN CHASE BANK, NA NEW YORK | ORIG ID=XXXXXXXX | DESC DATE=240202 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-08 00:00:00 | ACCOUNT NAME 5 | XXXXXXXX5 | EFT CREDIT | 23327 | CR | ACH | 23327 |  | 123456789 | 1234567899TC | ENTRY DATE=240208 | IND ID NO=123456789 | REMARK=TRN*1*XXXXXXXXXXXXXXXX* | ORIG CO NAME=KAISER FOUNDATIO | ORIG BANK=CITIBANK | ORIG ID=XXXXXXXX | DESC DATE=240206 | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT NAME 6 | XXXXXXXX6 | EFT CREDIT | 283.34 | CR | ACH | 283.34 |  | ACH123456789101 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=ACH123456789101 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=[PHONE] | ORIG BANK=WELLS FARGO BANK NA | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT
2024-02-09 00:00:00 | ACCOUNT NAME 6 | XXXXXXXX6 | EFT CREDIT | 40690.05 | CR | ACH | 40690.05 |  | ACH123456789101 | 1234567899TC | ENTRY DATE=240209 | IND ID NO=ACH123456789101 | REMARK=TRN*1*XXXXXXXXXX* | ORIG CO NAME=HORIZON | ORIG BANK=WELLS FARGO BANK NA | ORIG ID=XXXXXXXX | TRACE NO=XXXXXXXXXXXXXXX | IND NAME=Org Name | ENTRY CLASS=CCD | ENTRY DESCR=HCCLAIMPMT