Spreadsheet: 744679d1629380282-search-and-replace-with-value-from-another-tab-searchreplacepieces
Sheet: Sheet1

KeycodeImported | [NAME] | NM1_G2 | [NAME] | [NAME] | NM1_G5 | [NAME] | NM2_G1 | NM2_G2 | NM2_G3 | NM2_G4 | NM2_G5 | NM2_G6 | NM3_G1 | NM3_G2 | [NAME] | NM3_G4 | NM3_G5 | NM3_G6 | NM4_G1 | NM4_G2 | NM4_G3 | NM4_G4 | NM4_G5 | NM4_G6 | NM5_G1 | NM5_G2 | NM5_G3 | NM5_G4 | NM5_G5 | NM5_G6 | NM6_G1 | NM6_G2 | NM6_G3 | NM6_G4 | NM6_G5 | NM6_G6 | NM7_G1 | NM7_G2 | NM7_G3 | NM7_G4 | NM7_G5 | NM7_G6 | NM8_G1 | NM8_G2 | NM8_G3 | NM8_G4 | NM8_G5 | NM8_G6 | NM9_G1 | NM9_G2 | NM9_G3 | NM9_G4 | NM9_G5 | NM9_G6 | NM10_G1 | NM10_G2 | NM10_G3 | NM10_G4 | NM10_G5 | NM10_G6 | NM11_G1 | NM11_G2 | NM11_G3 | NM11_G4 | NM11_G5 | NM11_G6 | NM12_G1 | NM12_G2 | NM12_G3 | NM12_G4 | NM12_G5 | NM12_G6 | NM13_G1 | NM13_G2 | NM13_G3 | NM13_G4 | NM13_G5 | NM13_G6
M23740-6-178 | P01 | P03 | P04 | P07 | P08 | P16
M23740-6-179 | P02 | P07 | P09 | P11 | P13 |  | P03
M23740-6-180 | P01 | P02 | P05 | P06 | P08 | P10
M23740-8-181 | P07 |  |  |  |  |  | P03 | P04 | P05 | P08 | P09 | P11 | P04
M23740-8-182 | P02 | P03 | P07 | P08 | P09 | P16 | P09 | P14
M23740-8-183 | P02 | P07 | P14 | P17 |  |  | P02 | P04 | P09 | P14
M23740-8-184 | P01 |  |  |  |  |  | P03 | P09 | P10 | P14 |  |  | P02 | P07 | P09
M23740-13-185 | P03 | P06 | P07 | P12 |  |  | P12 |  |  |  |  |  | P04 | P06 | P07 | P08 | P10 |  | P02 | P06 |  |  |  |  | P03
What I would like:
KeycodeImported | [NAME] | NM1_G2 | [NAME] | [NAME] | NM1_G5 | [NAME] | NM2_G1 | NM2_G2 | NM2_G3 | NM2_G4 | NM2_G5 | NM2_G6 | NM3_G1 | NM3_G2 | [NAME] | NM3_G4 | NM3_G5 | NM3_G6 | NM4_G1 | NM4_G2 | NM4_G3 | NM4_G4 | NM4_G5 | NM4_G6 | NM5_G1 | NM5_G2 | NM5_G3 | NM5_G4 | NM5_G5 | NM5_G6 | NM6_G1 | NM6_G2 | NM6_G3 | NM6_G4 | NM6_G5 | NM6_G6 | NM7_G1 | NM7_G2 | NM7_G3 | NM7_G4 | NM7_G5 | NM7_G6 | NM8_G1 | NM8_G2 | NM8_G3 | NM8_G4 | NM8_G5 | NM8_G6 | NM9_G1 | NM9_G2 | NM9_G3 | NM9_G4 | NM9_G5 | NM9_G6 | NM10_G1 | NM10_G2 | NM10_G3 | NM10_G4 | NM10_G5 | NM10_G6 | NM11_G1 | NM11_G2 | NM11_G3 | NM11_G4 | NM11_G5 | NM11_G6 | NM12_G1 | NM12_G2 | NM12_G3 | NM12_G4 | NM12_G5 | NM12_G6 | NM13_G1 | NM13_G2 | NM13_G3 | NM13_G4 | NM13_G5 | NM13_G6
M23740-6-178 | P01 • MB269200 • RETINOL B3 ANTI-AGING SERUM 30ML | P03 | P04 | P07 | P08 | P16
M23740-6-179 | P01 • [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | P07 | P09 | P11 | P13 |  | P03
M23740-6-180 | P01 • MB269200 • RETINOL B3 ANTI-AGING SERUM 30ML | P01 • [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | P05 | P06 | P08 | P10
M23740-8-181 | P07 |  |  |  |  |  | P03 | P04 | P05 | P08 | P09 | P11 | P04
M23740-8-182 | P01 • [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | P03 | P07 | P08 | P09 | P16 | P09 | P14
M23740-8-183 | P01 • [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | P07 | P14 | P17 |  |  | P01 • [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | P04 | P09 | P14
M23740-8-184 | P01 • MB269200 • RETINOL B3 ANTI-AGING SERUM 30ML |  |  |  |  |  | P03 | P09 | P10 | P14 |  |  | P01 • [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | P07 | P09
M23740-13-185 | P03 | P06 | P07 | P12 |  |  | P12 |  |  |  |  |  | P04 | P06 | P07 | P08 | P10 |  | P01 • [PHONE] • ILLUMINATING BANANA LOOSE SETTING POWDER | P06 |  |  |  |  | P03