Spreadsheet: 748509d1632177478-dynamic-range-with-index-match-help-power-query-to-transform-with-conditions-brianbohannan91-
Sheet: WD's

Description | Date | Number | Payee | Account | Amount |  | Description | Post Date | Number | Payee | Account | Amount
ATT             -Payment319307011EPAYN | 2021-08-25 00:00:00 |  |  |  | 95.71 |  | AC-ATT             -Payment319307011EPAYN | 2021-08-25 00:00:00 | *7339 |  |  | 95.71
ATT             -Payment825067011EPAYR | 2021-08-03 00:00:00 |  |  |  | 380.74 |  | AC-ATT             -Payment825067011EPAYR | 2021-08-03 00:00:00 | *7339 |  |  | 380.74
CAPITAL ONE CARD-ONLINE PMTCKF617720214POS | 2021-08-13 00:00:00 |  |  |  | 7227.15 |  | AC-CAPITAL ONE CARD-ONLINE PMTCKF617720214POS | 2021-08-13 00:00:00 | *7339 |  |  | 7227.15
ACCOUNT ANALYSIS FEE | 2021-08-19 00:00:00 |  |  |  | 12.5 |  | ACCOUNT ANALYSIS FEE | 2021-08-19 00:00:00 | *7339 |  |  | 12.5
DRM INC.        -ONLINE PMTCKF617720214POS | 2021-08-31 00:00:00 |  |  |  | 725 |  | AC-DRM INC.        -ONLINE PMTCKF617720214POS | 2021-08-31 00:00:00 | *7339 |  |  | 725
EXECUPAY   21163-OBC IMPOUN464809789 | 2021-08-25 00:00:00 |  |  |  | 3317.97 |  | AC-EXECUPAY   21163-OBC IMPOUN464809789 | 2021-08-25 00:00:00 | *7339 |  |  | 3317.97
EXECUPAY   21163-OBC IMPOUN464809789 | 2021-08-12 00:00:00 |  |  |  | 3712.26 |  | AC-EXECUPAY   21163-OBC IMPOUN464809789 | 2021-08-12 00:00:00 | *7339 |  |  | 3712.26
Execupay  010JNV-Invoice464809789 | 2021-08-13 00:00:00 |  |  |  | 47.5 |  | AC-Execupay  010JNV-Invoice464809789 | 2021-08-13 00:00:00 | *7339 |  |  | 47.5
Execupay  010JNW-TAX IMPOUN464809789 | 2021-08-12 00:00:00 |  |  |  | 1061.8 |  | AC-Execupay  010JNW-TAX IMPOUN464809789 | 2021-08-12 00:00:00 | *7339 |  |  | 1061.8
Execupay  010N8h-Invoice464809789 | 2021-08-27 00:00:00 |  |  |  | 45.25 |  | AC-Execupay  010N8h-Invoice464809789 | 2021-08-27 00:00:00 | *7339 |  |  | 45.25
Execupay  010N8i-TAX IMPOUN464809789 | 2021-08-26 00:00:00 |  |  |  | 898.78 |  | AC-Execupay  010N8i-TAX IMPOUN464809789 | 2021-08-26 00:00:00 | *7339 |  |  | 898.78
SPRINT8006396111-ACHBILLPAY865345677 | 2021-08-19 00:00:00 |  |  |  | 138.76 |  | AC-SPRINT8006396111-ACHBILLPAY865345677 | 2021-08-19 00:00:00 | *7339 |  |  | 138.76
Tri-State Insura-INS PREM40001943 | 2021-08-16 00:00:00 |  |  |  | 526.92 |  | AC-Tri-State Insura-INS PREM40001943 | 2021-08-16 00:00:00 | *7339 |  |  | 526.92
VANGUARD BUY    -INVESTMENT271382925155509 | 2021-08-04 00:00:00 |  |  | Shareholder Distributions | 500 |  | AC-VANGUARD BUY    -INVESTMENT271382925155509 | 2021-08-04 00:00:00 | *7339 |  |  | 500
VANGUARD BUY    -INVESTMENT456496723101818 | 2021-08-02 00:00:00 |  |  | SEP Plan Expense | 833.33 |  | AC-VANGUARD BUY    -INVESTMENT456496723101818 | 2021-08-02 00:00:00 | *7339 |  |  | 833.33
Check | 2021-08-17 00:00:00 |  |  |  | 150 |  | Check | 2021-08-17 00:00:00 | *7339 |  |  | 150
LOAN PAYMENT                  TO   BL-0000000008252130 | 2021-08-16 00:00:00 |  |  |  | 561.57 |  | LOAN PAYMENT                  TO   BL-0000000008252130 | 2021-08-16 00:00:00 | *7339 |  |  | 561.57
 |  |  |  |  |  |  | AC-Execupay  010N8i-TAX IMPOUN464809789 | 2021-08-26 00:00:00 | *7339 |  |  | 898.78
 |  |  |  |  |  |  | AC-SPRINT8006396111-ACHBILLPAY865345677 | 2021-08-19 00:00:00 | *7339 |  |  | 138.76
 |  |  |  |  |  |  | AC-Tri-State Insura-INS PREM40001943 | 2021-08-16 00:00:00 | *7339 |  |  | 526.92
 |  |  |  |  |  |  | AC-VANGUARD BUY    -INVESTMENT271382925155509 | 2021-08-04 00:00:00 | *7339 |  |  | 500
 |  |  |  |  |  |  | AC-VANGUARD BUY    -INVESTMENT456496723101818 | 2021-08-02 00:00:00 | *7339 |  |  | 833.33
 |  |  |  |  |  |  | Check | 2021-08-17 00:00:00 | *7339 |  |  | 150
 |  |  |  |  |  |  | LOAN PAYMENT                  TO   BL-0000000008252130 | 2021-08-16 00:00:00 | *7339 |  |  | 561.57
 |  |  |  |  |  |  | AC-VANGUARD BUY    -INVESTMENT271382925155509 | 2021-08-04 00:00:00 | *7339 |  |  | 500
 |  |  |  |  |  |  | AC-VANGUARD BUY    -INVESTMENT456496723101818 | 2021-08-02 00:00:00 | *7339 |  |  | 833.33
 |  |  |  |  |  |  | Check | 2021-08-17 00:00:00 | *7339 |  |  | 150
 |  |  |  |  |  |  | LOAN PAYMENT                  TO   BL-0000000008252130 | 2021-08-16 00:00:00 | *7339 |  |  | 561.57
 |  |  |  |  |  |  | New WD | 2021-09-20 00:00:00 | *7339 |  |  | 1