Spreadsheet: 759621d1639633931-combine-multiple-rows-data-in-to-one-row-joining-data-in-column
Sheet: STATUS

 | G
PHASE | JOB | BLD | PH | Phase  MT | Customer | Shipment Balance | SS | Shipment Plan (Initial) | Month Ship. Plan | Month clearance | [NAME] (MTD) | Shipped. | [NAME] | SO | Job site | Sales Engineer | LC / BG | Phases Cleared | Phases Yet to Clear | Paint Spec. | [NAME]. | PBNS | BUILT-UP. | COLD FORM. | SHEETING. | NP | PHASE STATUS | SP Prod. Bal. | SP Ship Bal. | SP PBNS | TBR | YTP | [NAME]. | [NAME]. Bal. | SP [NAME]. Adj | [NAME]. Bal. N | SP [NAME]. Adj N | N | SP Prod. Bal. N | SP PBNS N | Production Balance | Prod. Bl | Date of Entry | Total Job Release | Total Job Release Bal. | Total Job Shipment by this month end | Total Job Shipment Bal. by month end | Release. | OS.B. | OS.C. | Plan B PBNS | Plan B Rel. Bal. | Plan B Prod. Bal. | Unplanned PBNS | Plan C | Plan C PBNS | Total Job Wt. | Total Job Shipped | Total Job Ship. Bal. | Cleared2 | To Be Cleared2 | Remarks | Column160 | Column161 | Column162 | Desired Result | Column163 | Column164 | Column165 | Column166 | Column167 | Column168 | Desired Result
HY-05840.01.61 | HY-05840 | A1 | 59 | 73.555 | B L KASHYAP |  |  | 14.031 | 14.031 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-05840.01.62 | HY-05840 | A1 | 60 | 97.846 | B L KASHYAP |  |  | 71.957 | 71.957 | 1 Cleared for Shipment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1/59,60 (OK)
HY-05856.01.19 | HY-05856 | A1 | 15 | 252.923 | AMARA RAJA INFRA |  |  | 37.641 | 37.641 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-05856.01.20 | HY-05856 | A1 | 16 | 36.065 | AMARA RAJA INFRA |  |  | 0.077 | 0.077 | 1 Cleared for Shipment | 0 | 39.54 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 6.902 |  |  |  |  | 0 | 6.902 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-05856.06.03 | HY-05856 | B1 | 2 | 369.568 | AMARA RAJA INFRA |  |  | 369.568 | 369.568 | 1 Cleared for Shipment | 0 | 18.195 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  | A1/15,16,B1/2 (A1/ missing)
HY-05856.08.03 | HY-05856 | C1 | 2 | 0 | AMARA RAJA INFRA |  |  |  |  |  | 0 | 18.027 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06133.01.11 | HY-06133 | A1 | 10 | 285.3459999999999 | ATC TYRES |  |  | 20.175 | 20.175 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 15.83 | 18.429 | 0 | 0.5780000000000001 |  |  |  |  | 0 | 34.872 |  |  |  |  |  |  |  |  | 34.259 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 34.259 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06133.01.12 | HY-06133 | A1 | 11 | 84.86800000000001 | ATC TYRES |  |  | 8.839 | 8.839 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06133.01.13 | HY-06133 | A1 | 12 | 84.488 | ATC TYRES |  |  | 84.488 | 84.488 | 2 Insp. Cleared | 0 | 64.008 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0.04 | 0 | 0.04 | 0 | 1.446 |  |  |  |  | 0 | 1.849 |  |  |  |  |  |  |  |  | 0.04 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 21.773 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  | A1/10,11,12 (not working)
HY-06133.01.14 | HY-06133 | A1 | 13 | 265.137 | ATC TYRES |  |  | 400 | 300 | 4 Insp. To be cleared | 0 | 1.9 | [NAME] | Chennai | PERAMBALUR |  | 0 |  |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  |  |  |  |  |  |  |  | A1/13
HY-06133.03.01 | HY-06133 | A1 | 50 | 3.785 | ATC TYRES |  |  |  |  |  | 0 | 8.197 | [NAME] | Chennai | PERAMBALUR |  | 0 |  |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06150.01.51 | HY-06150 | A1 | 31 | 0.038 |  |  |  | 0.038 | 0.038 | 1 Cleared for Shipment | 0 | 63.392 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 1.199 |  |  |  |  | 0 | 1.199 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06150.01.53 | HY-06150 | A1 | 66 | 141.969 |  |  |  | 141.969 |  | 9 PLAN B | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06150.01.48 | HY-06150 | A1 | 90 | 2.964 |  |  |  | 2.964 |  | 9 Drop out | 0 | 1.686 | [NAME] | Chennai | PERAMBALUR |  | 0 |  |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06150.01.32 | HY-06150 | A1 | 97 | 51.83200000000001 |  |  |  | 51.83200000000001 |  | 9 PLAN B | 0 | 7.846 | [NAME] | Chennai | PERAMBALUR |  | 0 |  |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06150.01.31 | HY-06150 | A1 | 98 | 88.57300000000001 |  |  |  | 0.869 | 0.869 | 1 Cleared for Shipment | 0 | 144.239 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 19.158 | 14.91 | 4.846 | 0 | 0.276 |  |  |  |  | 0 | 20.355 |  |  |  |  |  |  |  |  | 19.756 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 179.772 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  | A1/31,A1/98 (OK)
HY-06202.01.08 | HY-06202 | A1 | 7 | 102.254 | MRF |  |  | 0.019 | 0.019 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 127.846 | 4.094 | 27.237 | 0 | 3.514 |  |  |  |  | 0 | 35.408 |  |  |  |  |  |  |  |  | 31.331 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 159.178 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06202.01.10 | HY-06202 | A1 | 9 | 406.921 | MRF |  |  | 0.724 | 0.724 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 11.09 | 0 | 4.188 | 9.957 | 0.5329999999999999 |  |  |  |  | 0 | 17.623 |  |  |  |  |  |  |  |  | 14.145 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 25.235 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06202.01.11 | HY-06202 | A1 | 10 | 34.407 | MRF |  |  | 0.092 | 0.092 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 19.892 | 0 | 0.302 | 1.274 | 0.48 |  |  |  |  | 0 | 2.055 |  |  |  |  |  |  |  |  | 1.576 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 21.469 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  | A1/7,9,10 (A1/ missing)
HY-06207.01.03 | HY-06207 | A1 | 2 | 265.791 | DR. REDDY LABS |  |  | 48.689 | 48.689 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06207.01.04 | HY-06207 | A1 | 3 | 170.211 | DR. REDDY LABS |  |  | 170.211 | 170.211 | 2 Insp. Cleared | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-06207.01.09 | HY-06207 | A1 | 62 | 12.129 | DR. REDDY LABS |  |  | 6.94 | 6.94 | 1 Cleared for Shipment | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
[NAME] | HY-06207 | A1 | 63 | 111.366 | DR. REDDY LABS |  |  | 111.366 | 111.366 | 2 Insp. Cleared | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  | 0 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  | A1/2,3,62,63 (error)
HY-06207.01.06 | HY-06207 | A1 | 4 | 264.391 | DR. REDDY LABS |  |  | 150 |  | 9 PLAN B | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 0 | 0 | 4.808 | 3.646 | 29.32 |  |  |  |  | 0 | 40.693 |  |  |  |  |  |  |  |  | 11.373 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 11.373 | 0 | 2.919 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0
HY-80047.01.03.02 | HY-80047 | A1 | 1 | 511.109 | AMAZON (IR) |  |  |  | 75 | 8 Racking | 0 | 0 | [NAME] | Chennai | PERAMBALUR | [NAME] | 0 |  |  | M |  | 2.793 | 4.946 | 0.82 | 0 | 0.154 |  |  |  |  | 0 | 5.978 |  |  |  |  |  |  |  |  | 5.766 |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 8.559 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  | This should be blank)
HY-06316.01.04 | [NAME] | A1 | 99 | 12.65 | MIND SPACE SHELTERS |  |  | 12.637 | 12.637 | 1 Cleared for Shipment | 0 | 16.99 | [NAME] | Chennai | PERAMBALUR |  | 0 |  |  | M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-28 00:00:00 | 36.621 | 3494.219 |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 3530.84 | 2102.647 | 1428.193 |  |  | 0 |  |  |  | A1/99 (A1/ missing)
HY-06316.01.06 | [NAME] | A1 | 4 | 15.635 | MIND SPACE SHELTERS |  |  | 15.191 | 15.191 | 5 To be Cleared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1/4
HY-06237.01.28 | HY-06237 | A1 | 91 | 73.494 | GS PEB & CIVIL WORKS |  |  | 73.494 | 73.494 | 1 Cleared for Shipment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1/91 (not ok)
HY-06237.01.30 | HY-06237 | A1 | 93 | 79.43199999999999 | GS PEB & CIVIL WORKS
HY-06237.01.31 | HY-06237 | A1 | 94 | 45.668 | GS PEB & CIVIL WORKS |  |  | 10 | 10 | 6 Prodn Clearance Awtd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1/94
HY-06232.08.10 | HY-06232 | D1 | 9 | 0 | MRF |  |  | 9 | 9 | 5 To be Cleared
HY-06232.08.11 | HY-06232 | D1 | 10 | 40.693 | MRF |  |  | 40.693 | 40.693 | 1 Cleared for Shipment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1/10 (ok)
HY-06232.08.14 | HY-06232 | D1 | 62 | 8.770999999999999 | MRF |  |  | 8.770999999999999 | 8.770999999999999 | 5 To be Cleared |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1/9,62
Note:
1. The result taking only up to Two buildings i.e. A1,B1 and when [NAME] comes, it is not considering [NAME] and showing only B1,C1 buildings.  (Pl. check data in cell BP13 & BT19 above)
2. When we write "9 Drop Out" in Col.K, there should not be any impact in Col.BP.   (i.e. Col. BP it should ignore "9 Drop Out")
2. When we write any thing start with "9" in Col.K, there should not be any impact in Col.BP.   (i.e. Col. BP it should ignore any text begin with "9" as in "9 Drop Out", "9 Plan B" etc.)