Spreadsheet: 677313d1589301154-how-to-pull-single-line-data-from-one-tab-to-another-that-is-spaced-without-skipping-sample-file
Sheet: Raw Data

Cost Center | [NAME] | Customer-Nob Name-County State | SO Sales Group | Order Date | Order Total | [NAME] | Remaining Sales | Remaining COGS | Order_Requested_Ship | Line Delivery Date | MC | [NAME] | Area | Next 3 Months | Past Due | Undated/Beyond 2025
Easton | S061486 | Ames Construction (Burnsville) Marcellus LNG Production Facility BradfordPA | Terr5 | 2019-05-29 00:00:00 | 5541.5 | 3696.16 | 3304.7 | 2196.7708 | 2020-01-15 00:00:00 | 2020-05-01 00:00:00 | 1107.9292 | S061486 - Ames Construction (Burnsville) Marcellus LNG Production Facility BradfordPA | North | 0 | 3304.7 | 0
Easton | S063969 | [NAME] ECMS 93732 SR 220 Lycoming Co LycomingPA | Terr5 | 2020-02-13 00:00:00 | 135336 | 106243.5151 | 135336 | 106243.5151 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 29092.4849 | S063969 - Glenn O Hawbaker Inc. ECMS 93732 SR 220 Lycoming Co LycomingPA | North | 0 | 135336 | 0
Easton | S064867 | [NAME], Inc. Del Web @ Florham Park MorrisNJ | Terr12 | 2020-04-28 00:00:00 | 1400 | 789.1549 | 1400 | 789.1549 | 2020-05-01 00:00:00 | 2020-05-01 00:00:00 | 610.8451 | [NAME], Inc. Del Web @ Florham Park MorrisNJ | North | 0 | 1400 | 0
Easton | S064868 | TRA Electric, Inc. [NAME] TiogaPA | Terr13 | 2020-05-01 00:00:00 | 4003 | 2716.9165 | 4003 | 2716.9165 | 2020-05-01 00:00:00 | 2020-05-01 00:00:00 | 1286.0835 | S064868 - TRA Electric, Inc. [NAME] TiogaPA | North | 0 | 4003 | 0
Easton | S064875 | AMEC Electric, LLC The Hun School MercerNJ | Terr12 | 2020-04-30 00:00:00 | 2408 | 1605.8425 | 2408 | 1605.8425 | 2020-05-01 00:00:00 | 2020-05-01 00:00:00 | 802.1575 | S064875 - AMEC Electric, LLC The Hun School MercerNJ | North | 0 | 2408 | 0
Telford | S063842 | [NAME] at Blue Bell - culvert MONTGOMERYPA | Terr5 | 2020-01-22 00:00:00 | 53240 | 35509.451213 | 53240 | 35509.451213 | 2020-07-01 00:00:00 | 2020-05-01 00:00:00 | 17730.548787 | S063842 - Toll Bros Inc Creekside at Blue Bell - culvert MONTGOMERYPA | North | 0 | 53240 | 0
Easton | S064181 | Tri-M Group LLC Lehigh University NORTHAMPTONPA | Terr13 | 2020-02-27 00:00:00 | 11042 | 6551.8242 | 11042 | 6551.8242 | 2020-05-03 00:00:00 | 2020-05-03 00:00:00 | 4490.1758 | S064181 - Tri-M Group LLC Lehigh University NORTHAMPTONPA | North | 0 | 11042 | 0
Easton | S063455 | JC SONS EXCAVATING INC LVIP VII Lot 62 NorthamptoPA | Terr5 | 2019-12-13 00:00:00 | 748.64 | 436.88 | 748.64 | 436.88 | 2020-04-30 00:00:00 | 2020-05-04 00:00:00 | 311.76 | S063455 - JC SONS EXCAVATING INC LVIP VII Lot 62 NorthamptoPA | North | 0 | 748.64 | 0
Easton | S063969 | [NAME] ECMS 93732 SR 220 Lycoming Co LycomingPA | Terr5 | 2020-02-13 00:00:00 | 3483.22 | 1702.383521 | 3483.22 | 1702.383521 | 2020-04-30 00:00:00 | 2020-05-04 00:00:00 | 1780.836479 | S063969 - Glenn O Hawbaker Inc. ECMS 93732 SR 220 Lycoming Co LycomingPA | North | 0 | 3483.22 | 0
Easton | S064186 | Comroe Advanced Power, Inc TSW Alloy NORTHAMPTONPA | Terr13 | 2020-03-03 00:00:00 | 2553 | 1757.7856 | 2553 | 1757.7856 | 2020-05-04 00:00:00 | 2020-05-04 00:00:00 | 795.2144000000001 | S064186 - Comroe Advanced Power, Inc TSW Alloy NORTHAMPTONPA | North | 0 | 2553 | 0
Telford | S063969 | [NAME] ECMS 93732 SR 220 Lycoming Co LycomingPA | Terr5 | 2020-02-13 00:00:00 | 10136.57 | 7609.322537 | 10136.57 | 7609.322537 | 2020-04-30 00:00:00 | 2020-05-04 00:00:00 | 2527.247463 | S063969 - Glenn O Hawbaker Inc. ECMS 93732 SR 220 Lycoming Co LycomingPA | North | 0 | 10136.57 | 0
Telford | S063989 | Core Engineered Solutions Inc East Orange Water BUCKSPA | House | 2020-02-17 00:00:00 | 9162 | 5630.033421 | 9162 | 5630.033421 | 2020-05-04 00:00:00 | 2020-05-04 00:00:00 | 3531.966579 | S063989 - Core Engineered Solutions Inc East Orange Water BUCKSPA | North | 0 | 9162 | 0
Telford | S064161 | Core Engineered Solutions Inc Round Hill Center BUCKSPA | House | 2020-03-02 00:00:00 | 6772 | 5063.483029 | 6772 | 5063.483029 | 2020-05-04 00:00:00 | 2020-05-04 00:00:00 | 1708.516971 | S064161 - Core Engineered Solutions Inc Round Hill Center BUCKSPA | North | 0 | 6772 | 0
Telford | S064535 | Core Engineered Solutions Inc East Orange Water Dept BUCKSPA | House | 2020-03-30 00:00:00 | 13761 | 8920.664691 | 13761 | 8920.664691 | 2020-05-04 00:00:00 | 2020-05-04 00:00:00 | 4840.335309 | S064535 - Core Engineered Solutions Inc East Orange Water Dept BUCKSPA | North | 0 | 13761 | 0