Spreadsheet: 752483d1634795706-unique-for-multiple-columns-consolidator
Sheet: Tool-CWOP LE

Input Data in the Green areas, results populate in Blue, consolidated in Yellow
NOTE:  [NAME] are protected.  Unprotect sheet to change them.  No password.
 |  |  | 4116 Amount | 552398.8
Invoice | Date | Location | Region | Amount |  |  | MM/YY | DEPTID | PROGRAM | PROJECT_ID | APPROP | PCA | AY | ACCOUNT | ACCOUNT_DESCR | Amount | Description
 |  |  |  |  | Total
10658 | 2021-10-03 00:00:00 | San Antonio | 8A or 08 | 80640 |  |  |  |  |  |  |  | 03040 |  | 7299CW | Security for CWOP
10662 | 2021-10-03 00:00:00 | El Paso | 10 | 3835 |  |  | 10/21 | 10CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 3835 | 10662
10668 | 2021-09-26 00:00:00 | Corpus Christi | 11 |  |  |  | 09/21 | 11CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 9687 | 10668
10670 | 2021-10-03 00:00:00 | Midland | 09 | 4543 |  |  | 10/21 | 09CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 4543 | 10670
10671 | 2021-10-03 00:00:00 | mckinney | 3E | 23205 |  |  | 10/21 | 3ECDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 23205 | 10671
10674 | 2021-10-03 00:00:00 | [NAME] | 04 | 26812.5 |  |  | 10/21 | 04CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 26812.5 | 10674
10675 | 2021-10-03 00:00:00 | Lufkin | 05 | 29377 |  |  | 10/21 | 05CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 29377 | 10675
10676 | 2021-10-03 00:00:00 | Round Rock | 07 | 18720 |  |  | 10/21 | 07CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 18720 | 10676
10691 | 2021-10-03 00:00:00 | [NAME] | 6B (Invalid for FC; use 6A) | 28050 |  |  | 10/21 | 6ACDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 28050 | 10691
10692 | 2021-10-03 00:00:00 | Houston | 6A | 11040 |  |  | 10/21 | 6ACDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 11040 | 10692
10706 | 2021-10-10 00:00:00 | Seguin | 8B or 08 | 83038.8 |  |  | 10/21 | 08CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 83038.8 | 10706
10720 | 2021-10-10 00:00:00 | El Paso | 10 | 3055 |  |  | 10/21 | 10CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 3055 | 10720
10721 | 2021-10-10 00:00:00 | [NAME] | 04 | 25740 |  |  | 10/21 | 04CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 25740 | 10721
10722 | 2021-10-10 00:00:00 | Lufkin | 05 | 27057 |  |  | 10/21 | 05CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 27057 | 10722
10723 | 2021-10-10 00:00:00 | Round Rock | 07 | 19240 |  |  | 10/21 | 07CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 19240 | 10723
10724 | 2021-10-10 00:00:00 | Midland | 09 | 4543 |  |  | 10/21 | 09CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 4543 | 10724
10725 | 2021-10-07 00:00:00 | Richardson | 3E | 14982.5 |  |  | 10/21 | 3ECDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 14982.5 | 10725
10730 | 2021-10-08 00:00:00 | [NAME] | 6B (Invalid for FC; use 6A) | 22620 |  |  | 10/21 | 6ACDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 22620 | 10730
10731 | 2021-10-10 00:00:00 | Houston | 6A | 14880 |  |  | 10/21 | 6ACDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 14880 | 10731
10732 | 2021-10-10 00:00:00 | Corpus Christi | 11 | 50342.5 |  |  | 10/21 | 11CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 50342.5 | 10732
10668 | 2021-10-03 00:00:00 | Corpus Christi | 11 |  |  |  | 10/21 | 11CDDOTH | 11000 | 22-0530CPSTS | 13040 |  | 2022 |  |  | 50990.5 | 10668
 |  |  |  |  |  |  | Consolidator |  |  |  |  |  |  |  |  | Amount | Description
 |  |  |  |  |  |  | MM/YY | DEPTID | PROGRAM | PROJECT_ID | APPROP | PCA | AY | ACCOUNT | ACCOUNT_DESCR
 |  |  |  |  |  |  |  | 08CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW
 |  |  |  |  |  |  | 10/21 | 10CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 6890
 |  |  |  |  |  |  | 09/21 | 11CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 111020
 |  |  |  |  | In |  | 10/21 | 09CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 9086
 |  |  |  |  |  |  | 10/21 | 3ECDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 38187.5
 |  |  |  |  |  |  | 10/21 | 04CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 52552.5
 |  |  |  |  |  |  | 10/21 | 05CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 56434
 |  |  |  |  |  |  | 10/21 | 07CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 37960
 |  |  |  |  |  |  | 10/21 | 6ACDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 76590
 |  |  |  |  |  |  | 10/21 | 11CDDOTH | 11000 | 22-0530CPSTS | 13040 | 03040 | 2022 | 7299CW |  | 111020