Spreadsheet: 759032d1639240449-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-06230.01.08 |  | A1 | 1 | 0 | MRF |  | 0 | 2 | 2 | 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 |  |  |  | A1/1
HY-06230.01.09 |  | A1 | 2
HY-06230.01.10 |  | A1 | 3 | 0 | MRF |  | 0 | 20 | 20 | 5 To be 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/3
HY-06232.01.11 |  | A1 | 10 | 46.442 | MRF | 6.902 | 0 | 6.902 | 6.902 | 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
[NAME] |  | B1 | 6 | 18.195 | MRF |  | 0 |  |  |  | 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
HY-06232.06.08 |  | B1 | 7 | 18.027 | MRF |  | 0 | 20 |  | 9 PLAN B | 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-06232.06.09 |  | B1 | 8 | 0 | MRF | 34.872 | 0 | 34.872 | 34.872 | 5 To be Cleared | 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-06232.06.10 |  | B1 | 9 | 0 | MRF | 0 | 0 |  |  |  | 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-06232.06.11 |  | B1 | 10 | 65.59700000000001 | MRF | 1.889 | 0 | 1.889 | 1.889 | 1 Cleared for Shipment | 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
HY-06232.06.14 |  | B1 | 62 | 0 | MRF |  | 0 |  |  |  | 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
HY-06232.07.02 |  | C1 | 1 | 0 | MRF |  | 0 |  |  |  | 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-06232.07.09 |  | C1 | 8 | 64.591 | MRF | 1.199 | 0 | 1.199 | 1.199 | 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 |  |  |  | A1/10,B1/10,C1/8
HY-06232.07.10 |  | C1 | 63 | 0 | MRF | 0 | 0 | 10 | 10 | 5 To be 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-06232.07.14 |  | C1 | 62 | 0 | MRF |  | 0 |  |  |  | 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-06232.08.02 |  | D1 | 1 | 0 | MRF |  | 0 |  |  |  | 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-06232.08.03 |  | D1 | 2 | 183.75 | MRF | 39.513 | 0 |  |  |  | 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
HY-06232.08.04 |  | D1 | 3 | 162.638 | MRF | 163.254 | 0 | 163.254 | 163.254 | 5 To be Cleared | 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-06232.08.05 |  | D1 | 4 | 40 | MRF | 28.713 | 0 | 28.713 | 28.713 | 5 To be Cleared | 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 |  |  |  |  |  |  |  |  |  |  | B1/8,C1/63,D1/3,4
HY-06232.08.06 |  | D1 | 5 | 0 | MRF | 21.947 | 0 | 21.947 |  | 9 Drop out | 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
HY-06306.01.02 |  | A1 | 1 | 0 | MRF | 0 | 0 |  |  |  | 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-06306.01.03 |  | A1 | 2 | 0 | MRF | 0 | 0 | 13.082 | 13.082 | 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] |  | A1 | 3 | 0 | MRF | 0 | 0 | 13.149 | 13.149 | 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-06306.01.05 |  | A1 | 4 | 0 | MRF | 0 | 0 | 142.064 | 142.064 | 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-06306.01.06 |  | A1 | 5 | 10.377 | MRF | 40.693 | 0 | 180 | 180 | 1 Cleared for Shipment | 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 |  |  |  | A1/2,3,4,5
HY-06306.01.07 |  | A1 | 6 | 8.770999999999999 | MRF | 8.770999999999999 | 0 | 200 |  | 9 PLAN B | 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
HY-06306.01.08 |  | A1 | 7 | 0 | MRF |  | 0 | 100 |  |  | 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
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.)