Spreadsheet: 748509d1632177478-dynamic-range-with-index-match-help-power-query-to-transform-with-conditions-brianbohannan91-
Sheet: Raw Data

Acct. | Post Date | Check | Description | Debit | Credit | Status
*7339 | 2021-08-02 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-A3S8E2A8A1G9 |  | 7070.88 | Posted
*7339 | 2021-08-20 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-D8Z2L3R1J6Y5 |  | 6002.11 | Posted
*7339 | 2021-08-31 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-P4S7T2B9A1S4 |  | 4591.95 | Posted
*7339 | 2021-08-20 00:00:00 |  | Deposit/Credit |  | 3837.84 | Posted
*7339 | 2021-08-25 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-X9L2F3R5C2P0 |  | 3580.87 | Posted
*7339 | 2021-08-10 00:00:00 |  | Deposit/Credit |  | 3119.2 | Posted
*7339 | 2021-08-05 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-C2G6V6Q6T0K5 |  | 2620.36 | Posted
*7339 | 2021-08-03 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-H9U5B9S1X9C2 |  | 2564.58 | Posted
*7339 | 2021-08-31 00:00:00 |  | Deposit/Credit |  | 1514 | Posted
*7339 | 2021-08-04 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-G2B2C6O2Z3W2 |  | 1081.48 | Posted
*7339 | 2021-08-23 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-Q8L0S2D8V8Q9 |  | 902.04 | Posted
*7339 | 2021-08-12 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-D1Q0K8K8D2F3 |  | 901.27 | Posted
*7339 | 2021-08-17 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-P7O0N5H0I5P1 |  | 692.08 | Posted
*7339 | 2021-08-18 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-U5A0I4C2M8H5 |  | 349.98 | Posted
*7339 | 2021-08-26 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-H4F1T4I0A4H4 |  | 291.6 | Posted
*7339 | 2021-08-27 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-O6V3R3Y1T3R0 |  | 204.03 | Posted
*7339 | 2021-08-19 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-G0N5P9K0P7Z4 |  | 98.95 | Posted
*7339 | 2021-08-30 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-K8X0T1K8X7B3 |  | 97.97 | Posted
*7339 | 2021-08-16 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-D8Q3Q9J5Z2U4 |  | 92.13 | Posted
*7339 | 2021-08-11 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-V8B2D1K2W1T8 |  | 86.3 | Posted
*7339 | 2021-08-06 00:00:00 |  | AC-Jobber - By Stri-TRANSFERST-E3C7H0Y3P6R0 |  | 67.81 | Posted
*7339 | 2021-08-11 00:00:00 | 1405 | Check | 1710 |  | Posted
*7339 | 2021-08-02 00:00:00 | 1404 | Check | 4000 |  | Posted
*7339 | 2021-08-25 00:00:00 |  | AC-ATT             -Payment319307011EPAYN | 95.71 |  | Posted
*7339 | 2021-08-03 00:00:00 |  | AC-ATT             -Payment825067011EPAYR | 380.74 |  | Posted
*7339 | 2021-08-13 00:00:00 |  | AC-CAPITAL ONE CARD-ONLINE PMTCKF617720214POS | 7227.15 |  | Posted
*7339 | 2021-08-19 00:00:00 |  | ACCOUNT ANALYSIS FEE | 12.5 |  | Posted
*7339 | 2021-08-31 00:00:00 |  | AC-DRM INC.        -ONLINE PMTCKF617720214POS | 725 |  | Posted
*7339 | 2021-08-25 00:00:00 |  | AC-EXECUPAY   21163-OBC IMPOUN464809789 | 3317.97 |  | Posted
*7339 | 2021-08-12 00:00:00 |  | AC-EXECUPAY   21163-OBC IMPOUN464809789 | 3712.26 |  | Posted
*7339 | 2021-08-13 00:00:00 |  | AC-Execupay  010JNV-Invoice464809789 | 47.5 |  | Posted
*7339 | 2021-08-12 00:00:00 |  | AC-Execupay  010JNW-TAX IMPOUN464809789 | 1061.8 |  | Posted
*7339 | 2021-08-27 00:00:00 |  | AC-Execupay  010N8h-Invoice464809789 | 45.25 |  | Posted
*7339 | 2021-08-26 00:00:00 |  | AC-Execupay  010N8i-TAX IMPOUN464809789 | 898.78 |  | Posted
*7339 | 2021-08-19 00:00:00 |  | AC-SPRINT8006396111-ACHBILLPAY865345677 | 138.76 |  | Posted
*7339 | 2021-08-16 00:00:00 |  | AC-Tri-State Insura-INS PREM40001943 | 526.92 |  | Posted
*7339 | 2021-08-04 00:00:00 |  | AC-VANGUARD BUY    -INVESTMENT271382925155509 | 500 |  | Posted
*7339 | 2021-08-02 00:00:00 |  | AC-VANGUARD BUY    -INVESTMENT456496723101818 | 833.33 |  | Posted
*7339 | 2021-08-17 00:00:00 |  | Check | 150 |  | Posted
*7339 | 2021-08-16 00:00:00 |  | LOAN PAYMENT                  TO   BL-0000000008252130 | 561.57 |  | Posted
*7339 | 2021-08-26 00:00:00 |  | AC-Execupay  010N8i-TAX IMPOUN464809789 | 898.78 |  | Posted
*7339 | 2021-08-19 00:00:00 |  | AC-SPRINT8006396111-ACHBILLPAY865345677 | 138.76 |  | Posted
*7339 | 2021-08-16 00:00:00 |  | AC-Tri-State Insura-INS PREM40001943 | 526.92 |  | Posted
*7339 | 2021-08-04 00:00:00 |  | AC-VANGUARD BUY    -INVESTMENT271382925155509 | 500 |  | Posted
*7339 | 2021-08-02 00:00:00 |  | AC-VANGUARD BUY    -INVESTMENT456496723101818 | 833.33 |  | Posted
*7339 | 2021-08-17 00:00:00 |  | Check | 150 |  | Posted
*7339 | 2021-08-16 00:00:00 |  | LOAN PAYMENT                  TO   BL-0000000008252130 | 561.57 |  | Posted
*7339 | 2021-08-04 00:00:00 |  | AC-VANGUARD BUY    -INVESTMENT271382925155509 | 500 |  | Posted
*7339 | 2021-08-02 00:00:00 |  | AC-VANGUARD BUY    -INVESTMENT456496723101818 | 833.33 |  | Posted
*7339 | 2021-08-17 00:00:00 |  | Check | 150 |  | Posted
*7339 | 2021-08-16 00:00:00 |  | LOAN PAYMENT                  TO   BL-0000000008252130 | 561.57 |  | Posted
*7339 | 2021-09-20 00:00:00 |  | New Deposit |  | 1
*7339 | 2021-09-20 00:00:00 | 1 | New Check | 1
*7339 | 2021-09-20 00:00:00 |  | New WD | 1