Spreadsheet: 879442d1726965100-how-to-leave-out-any-columns-that-have-all-0-00-in-them-testfile
Sheet: Co-Loader Charges

Co-Loader Charges
 |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges.
Co-Loader: |  | CoLoad-1
Date | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | Co-Loader | Co-Loader Total Chgs: | Ocean Freight (Collect) | General Rate Increase (GRI) Charge | Emergency Peak Season Charge | SOLAS VGM Fee | Other Charges | Overweight/OverDim Chg | THC/ Origin HC | [NAME] to Customer | CBP Processing Fee/ACD | Stripping | Stripping Charge | De-Vanning | L.O.T. Fee | Low Water Charge | Panama Canal Charge (PCC) | CFS/ Documentation Fee | [NAME] | CFS Loading Fee | On Carriage | Loading/ Unloading Charge | Wharfage Chge | Warehouse charge | Ins or Container Protect Unlimited (Ins) | In/Out Charge/ InBound Fee | Window Facility Fee | Pier Surchg/ Container Port Charge | Port Congestion Charge | IPI (Truck/Rail) Congestion | Emergency Port Congestion Chg | [NAME] | Toll Fee | [NAME] (DAD/ DDC) | Cargo Facility Chg (CFC)/ Dest Deliv Charge | Labor & Trans/ Doc Trans Fee/ Inland Frght | Permit To Transfer (PTT) | I.T. Prep | [NAME] | Chassis Usage/ Suchg (CUC) | Turn in Fee | Equip Imbalance Chg | Equip Schg | Emission trading System (ETS) | Clean Truck (Fuel) Fee | Low Sulfur or [NAME] | CFS Fuel Schg | IMO2020 (Fuel) Charge | CFS/Port Sec I.S.P.S. Fee | Carrier Security Fee
 | Client-1 | 1 | Barcelona | NY | Boston | 1-pallet | 68 | 0.315 | LCL | CoLoad-1 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0
2023-09-15 00:00:00 | Client-1 | 2 | Barcelona | NY | Boston | 1-pkg | 92 | 0.24 | LCL | CoLoad-1 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0
2023-09-26 00:00:00 | Client-1 | 3 | Barcelona | NY | Boston | 9-box | 2136 | 2.458 | LCL | CoLoad-1 | 294.84 | 0 | 0 | 0 | 0 | 0 | 0 | 61.45 | 0 | 0 | 30.73 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 17.66 | 0 | 0 | 35 | 0 | 0 | 45 | 0
2023-10-04 00:00:00 | Client-1 | 4 | Barcelona | NY | Boston | 5-box | 1735 | 2.021 | LCL | CoLoad-1 | 275.13 | 0 | 0 | 0 | 0 | 0 | 0 | 50.53 | 0 | 0 | 25.26 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 14.34 | 0 | 0 | 0 | 35 | 0 | 45 | 0
2023-10-05 00:00:00 | Client-1 | 5 | Barcelona | NY | Boston | 1-box | 72 | 0.15 | LCL | CoLoad-1 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0
2023-10-17 00:00:00 | Client-1 | 6 | Barcelona | NY | Boston | 1-box | 103 | 0.17 | LCL | CoLoad-1 | 270 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10 | 0 | 0 | 0 | 35 | 0 | 45 | 0
2023-10-19 00:00:00 | Client-1 | 7 | [NAME] | NY | Boston | 5-box | 1310 | 1.53 | LCL | CoLoad-1 | 270.83 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 10.83 | 0 | 0 | 0 | 35 | 0 | 45 | 0
2023-10-26 00:00:00 | Client-1 | 8 | [NAME] | NY | Boston | 5 | 2170 | 1.94 | LCL | CoLoad-1 | 284.32 | 0 | 0 | 0 | 0 | 0 | 0 | 54.25 | 0 | 0 | 27.13 | 0 | 0 | 0 | 0 | 0 | 0 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 35 | 0 | 15 | 0 | 0 | 17.94 | 0 | 0 | 0 | 35 | 0 | 45 | 0