Spreadsheet: 806226d1669177855-deletes-multiple-words-in-a-cell-based-on-the-cell-next-to-it-contoh-masalah1
Sheet: Sheet1

 |  |  |  |  |  | Desired Result
Product name | Code | brand |  |  |  | Product Name
[NAME] 17 | VON 17 | Everflow |  |  |  | [NAME]
[NAME] 17 | VON 17 | Everflow |  |  |  | [NAME]
[NAME] 17 | VON 17 | Everflow |  |  |  | [NAME]
[NAME] VGG 008 | VGG 008 | Everflow |  |  |  | [NAME]
[NAME] VGG 008 | VGG 008 | Everflow |  |  |  | [NAME]
[NAME] VDL 37 | VDL 37 | Everflow |  |  |  | [NAME]
[NAME] VDL 37 | VDL 37 | Everflow |  |  |  | [NAME]
[NAME] VDL 37 | VDL 37 | Everflow |  |  |  | [NAME]
[NAME] 05 | VON 05 | Everflow |  |  |  | [NAME]
[NAME] 05 | VON 05 | Everflow |  |  |  | [NAME]
[NAME] VGG 034 | VGG 034 | Everflow |  |  |  | [NAME]
[NAME] VGG 034 | VGG 034 | Everflow |  |  |  | [NAME]
[NAME] VGG 034 | VGG 034 | Everflow |  |  |  | [NAME]
[NAME] VGG 036 | VGG 036 | Everflow |  |  |  | [NAME]
[NAME] VGG 036 | VGG 036 | Everflow |  |  |  | [NAME]
[NAME] VGG 036 | VGG 036 | Everflow |  |  |  | [NAME]
[NAME] 13 | VON 13 | Everflow |  |  |  | [NAME]
[NAME] 13 | VON 13 | Everflow |  |  |  | [NAME]
[NAME] 13 | VON 13 | Everflow |  |  |  | [NAME]
[NAME] VDL 31 | VDL 31 | Everflow |  |  |  | [NAME]
[NAME] VDL 31 | VDL 31 | Everflow |  |  |  | [NAME]
[NAME] VDL 31 | VDL 31 | Everflow |  |  |  | [NAME]
[NAME] VGG 033 | VGG 033 | Everflow |  |  |  | [NAME]
[NAME] VGG 033 | VGG 033 | Everflow |  |  |  | [NAME]
[NAME] VGG 033 | VGG 033 | Everflow |  |  |  | [NAME]
[NAME] 14 | VON 14 | Everflow |  |  |  | [NAME]
[NAME] 14 | VON 14 | Everflow |  |  |  | [NAME]
[NAME] 14 | VON 14 | Everflow |  |  |  | [NAME]
[NAME] VDL 36 | VDL 36 | Everflow |  |  |  | [NAME]
[NAME] VDL 36 | VDL 36 | Everflow |  |  |  | [NAME]
[NAME] VDL 36 | VDL 36 | Everflow |  |  |  | [NAME]
[NAME] 02 | VON 02 | Everflow |  |  |  | [NAME]
[NAME] 02 | VON 02 | Everflow |  |  |  | [NAME]
[NAME] VGG 038 | VGG 038 | Everflow |  |  |  | [NAME]
[NAME] VGG 038 | VGG 038 | Everflow |  |  |  | [NAME]
[NAME] VGG 038 | VGG 038 | Everflow |  |  |  | [NAME]
[NAME] 10 | VON 10 | Everflow |  |  |  | [NAME]
[NAME] 10 | VON 10 | Everflow |  |  |  | [NAME]
[NAME] 10 | VON 10 | Everflow |  |  |  | [NAME]
[NAME] 10 | VTH 10 | Everflow |  |  |  | [NAME]
[NAME] 10 | VTH 10 | Everflow |  |  |  | [NAME]
[NAME] 10 | VTH 10 | Everflow |  |  |  | [NAME]
[NAME] 16 | VON 16 | Everflow |  |  |  | [NAME]
[NAME] 16 | VON 16 | Everflow |  |  |  | [NAME]
[NAME] 16 | VON 16 | Everflow |  |  |  | [NAME]
[NAME] VGG 001 | VGG 001 | Everflow |  |  |  | [NAME]
[NAME] VGG 001 | VGG 001 | Everflow |  |  |  | [NAME]
[NAME] VGG 007 | VGG 007 | Everflow |  |  |  | [NAME]
[NAME] VGG 007 | VGG 007 | Everflow |  |  |  | [NAME]
[NAME] VGG 031 | VGG 031 | Everflow |  |  |  | [NAME]
[NAME] VGG 031 | VGG 031 | Everflow |  |  |  | [NAME]
[NAME] VGG 031 | VGG 031 | Everflow |  |  |  | [NAME]
[NAME] VGG 032 | VGG 032 | Everflow |  |  |  | [NAME]
[NAME] VGG 032 | VGG 032 | Everflow |  |  |  | [NAME]
[NAME] VGG 032 | VGG 032 | Everflow |  |  |  | [NAME]
[NAME] VGG 030 | VGG 030 | Everflow |  |  |  | [NAME]
[NAME] VGG 030 | VGG 030 | Everflow |  |  |  | [NAME]
[NAME] VGG 030 | VGG 030 | Everflow |  |  |  | [NAME]
[NAME] VDL 33 | VDL 33 | Everflow |  |  |  | [NAME]
[NAME] VDL 33 | VDL 33 | Everflow |  |  |  | [NAME]
[NAME] VDL 33 | VDL 33 | Everflow |  |  |  | [NAME]
[NAME] VGG 004 | VGG 004 | Everflow |  |  |  | [NAME]
[NAME] VGG 004 | VGG 004 | Everflow |  |  |  | [NAME]
[NAME] 15 | VON 15 | Everflow |  |  |  | [NAME]
[NAME] 15 | VON 15 | Everflow |  |  |  | [NAME]
[NAME] 15 | VON 15 | Everflow |  |  |  | [NAME]
[NAME] 11 | VON 11 | Everflow |  |  |  | [NAME]
[NAME] 11 | VON 11 | Everflow |  |  |  | [NAME]
[NAME] 11 | VON 11 | Everflow |  |  |  | [NAME]
[NAME] VDL 38 | VDL 38 | Everflow |  |  |  | [NAME]
[NAME] VDL 38 | VDL 38 | Everflow |  |  |  | [NAME]
[NAME] VDL 38 | VDL 38 | Everflow |  |  |  | [NAME]
[NAME] VGG 037 | VGG 037 | Everflow |  |  |  | [NAME]
[NAME] VGG 037 | VGG 037 | Everflow |  |  |  | [NAME]
[NAME] VGG 037 | VGG 037 | Everflow |  |  |  | [NAME]
[NAME] 12 | VON 12 | Everflow |  |  |  | [NAME]
[NAME] 12 | VON 12 | Everflow |  |  |  | [NAME]
[NAME] 12 | VON 12 | Everflow |  |  |  | [NAME]
[NAME] VGG 035 | VGG 035 | Everflow |  |  |  | [NAME]
[NAME] VGG 035 | VGG 035 | Everflow |  |  |  | [NAME]
[NAME] VGG 035 | VGG 035 | Everflow |  |  |  | [NAME]
[NAME] VGG 090 | VGG 090 | Everflow |  |  |  | [NAME]
[NAME] VGG 090 | VGG 090 | Everflow |  |  |  | [NAME]
[NAME] VGG 090 | VGG 090 | Everflow |  |  |  | [NAME]
[NAME] VGG 016 | VGG 016 | Everflow |  |  |  | [NAME]
[NAME] VGG 016 | VGG 016 | Everflow |  |  |  | [NAME]
[NAME] 11 | VTH 11 | Everflow |  |  |  | [NAME]
[NAME] 11 | VTH 11 | Everflow |  |  |  | [NAME]
[NAME] 11 | VTH 11 | Everflow |  |  |  | [NAME]
[NAME] VGG 010 | VGG 010 | Everflow |  |  |  | [NAME]
[NAME] VGG 010 | VGG 010 | Everflow |  |  |  | [NAME]
[NAME] 886 | KMT 886 | Kuzatura |  |  |  | [NAME]
[NAME] 886 | KMT 886 | Kuzatura |  |  |  | [NAME]
[NAME] 886 | KMT 886 | Kuzatura |  |  |  | [NAME]
[NAME] 110 | KLX 110 | Kuzatura |  |  |  | [NAME]
[NAME] 110 | KLX 110 | Kuzatura |  |  |  | [NAME]
[NAME] 110 | KLX 110 | Kuzatura |  |  |  | [NAME]
Kaos / T-Shirt Pria Java Seven JUC 415 | JUC 415 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven JUC 415 | JUC 415 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven JUC 409 | JUC 409 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven JUC 409 | JUC 409 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven MRJ 219 | MRJ 219 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven MRJ 219 | MRJ 219 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven DED 626 | DED 626 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven DED 626 | DED 626 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven DED 626 | DED 626 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven MRJ 218 | MRJ 218 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Kaos / T-Shirt Pria Java Seven MRJ 218 | MRJ 218 | [NAME] Seven |  |  |  | Kaos / T-Shirt Pria
Inficlo Pria Pakaian T-shirt  SFC INF 278 | SFC INF 278 | Inficlo |  |  |  | Pria Pakaian T-shirt
Inficlo Pria Pakaian T-shirt  SFC INF 278 | SFC INF 278 | Inficlo |  |  |  | Pria Pakaian T-shirt
Inficlo Pria Pakaian T-shirt SGU INF 861 | SGU INF 861 | Inficlo |  |  |  | Pria Pakaian T-shirt
Inficlo Pria Pakaian T-shirt SGU INF 861 | SGU INF 861 | Inficlo |  |  |  | Pria Pakaian T-shirt
Inficlo Pria Pakaian T-shirt SGN INF 115 | SGN INF 115 | Inficlo |  |  |  | Pria Pakaian T-shirt
Inficlo Pria Pakaian T-shirt SGN INF 115 | SGN INF 115 | Inficlo |  |  |  | Pria Pakaian T-shirt
T-Shirt Casual Pria KLX KZR 427 | [NAME] 427 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 427 | [NAME] 427 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 427 | [NAME] 427 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 657 | KMT KZR 657 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 657 | KMT KZR 657 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 657 | KMT KZR 657 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 433 | KRO KZR 433 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 433 | KRO KZR 433 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 433 | KRO KZR 433 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KPU KZR 667 | KPU KZR 667 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KPU KZR 667 | KPU KZR 667 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KPU KZR 667 | KPU KZR 667 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 372 | [NAME] | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 372 | [NAME] | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 372 | [NAME] | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 744 | KRO KZR 744 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 744 | KRO KZR 744 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 744 | KRO KZR 744 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 597 | KRO KZR 597 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 597 | KRO KZR 597 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 597 | KRO KZR 597 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Raglan Pria KRO KZR 772 | KRO KZR 772 | Blackkelly |  |  |  | T-Shirt Raglan Pria
T-Shirt Raglan Pria KRO KZR 772 | KRO KZR 772 | Blackkelly |  |  |  | T-Shirt Raglan Pria
T-Shirt Raglan Pria KRO KZR 772 | KRO KZR 772 | Blackkelly |  |  |  | T-Shirt Raglan Pria
T-Shirt Casual Pria KMT KZR 613 | KMT KZR 613 | Blackkelly |  |  |  | T-Shirt Raglan Pria
T-Shirt Casual Pria KMT KZR 613 | KMT KZR 613 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 613 | KMT KZR 613 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 556 | KLX KZR 556 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 556 | KLX KZR 556 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 578 | [NAME] 578 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 578 | [NAME] 578 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 578 | [NAME] 578 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KSD KZR 382 | KSD KZR 382 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KSD KZR 382 | KSD KZR 382 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KSD KZR 382 | KSD KZR 382 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KSD KZR 415 | KSD KZR 415 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KSD KZR 415 | KSD KZR 415 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KSD KZR 415 | KSD KZR 415 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 324 | [NAME] 324 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 324 | [NAME] 324 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KLX KZR 324 | [NAME] 324 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 867 | KMT KZR 867 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 867 | KMT KZR 867 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 867 | KMT KZR 867 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 942 | KRO KZR 942 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 942 | KRO KZR 942 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KRO KZR 942 | KRO KZR 942 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 322 | KMT KZR 322 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 322 | KMT KZR 322 | Blackkelly |  |  |  | T-Shirt Casual Pria
T-Shirt Casual Pria KMT KZR 322 | KMT KZR 322 | Blackkelly |  |  |  | T-Shirt Casual Pria
Wangky Pria CBR SIX FFC 263 | FFC 263 | CBR Six |  |  |  | Wangky Pria
Wangky Pria CBR SIX FFC 263 | FFC 263 | CBR Six |  |  |  | Wangky Pria
Wangky Pria CBR SIX FFC 263 | FFC 263 | CBR Six |  |  |  | Wangky Pria
Wangky Pria CBR SIX FFC 267 | FFC 267 | CBR Six |  |  |  | Wangky Pria
Wangky Pria CBR SIX FFC 267 | FFC 267 | CBR Six |  |  |  | Wangky Pria
Wangky Pria CBR SIX FFC 267 | FFC 267 | CBR Six |  |  |  | Wangky Pria