Spreadsheet: 782694d1654186154-adding-a-character-to-mark-the-end-of-sequence-sample1
Sheet: Sheet1

KEYCODE | STOP_CODE | NAME | SKU | DESC | STORE | [NAME] | CITY | PROV | PC | UNIQUECODE | UNIQUECODE Count | SEQ
M12345-1-001 |  | SAVOIE ELLA | [PHONE] | LIFE PLANKTON ™ ELIXIR - REGENERATING & ANTI-AGING SERUM | SHOPPERS DRUG MART#0136 | 278 LACEWOOD DR | HALIFAX | NS | B3M 3N8 | B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | 3916 | 1
M12345-2-038 |  | PARE FREDERIQUE | LC677100 | LA VIE EST BELLE SOLEIL CRISTAL | UNPX #031286 COURVILLE PHARMA INC | 1100 AVE LARUE | COURVILLE | QC | [NAME] 6H4 | [NAME] #031286 COURVILLE PHARMA INC1100 AVE LARUE | 3916 | 38
M12345-2-038 |  | PARE FREDERIQUE | [NAME] | EFFACLAR ULTRA CONCENTRATED SERUM 30ML | UNPX #031286 COURVILLE PHARMA INC | 1100 AVE LARUE | COURVILLE | QC | [NAME] 6H4 | [NAME] #031286 COURVILLE PHARMA INC1100 AVE LARUE | 3916 | 38
M12345-2-039 |  | COTE EMMANUELLE | LC677100 | LA VIE EST BELLE SOLEIL CRISTAL | PHARMAPRIX #1927 | 835 BOUL .RENE-LEVESQUE O. | QUEBEC | QC | [NAME] | G1S 1T4PHARMAPRIX #1927835 BOUL .RENE-LEVESQUE O. | 3916 | 39
M12345-2-039 |  | COTE EMMANUELLE | [PHONE] | CICAPLAST BAUME B5 40ML | PHARMAPRIX #1927 | 835 BOUL .RENE-LEVESQUE O. | QUEBEC | QC | [NAME] | G1S 1T4PHARMAPRIX #1927835 BOUL .RENE-LEVESQUE O. | 3916 | 39
M12345-2-040 |  | D.-ROY SONIA | [PHONE] | L'ABSOLU ROUGE INTIMATTE - SHADE: 888 | 1501, [NAME] (QUEBEC) G2E 4A9 | 1501, RUE J.-F.-MARTEL | QUEBEC | ON | G2E 4A9 | G2E 4A91501, [NAME] (QUEBEC) G2E 4A91501, RUE J.-F.-MARTEL | 3916 | 40
M12345-2-040 |  | D.-ROY SONIA | [PHONE] | YSL ROUGE VOLUPTE SHINE OIL AND STICK - SHADE 84 RED CASSANDRE | 1501, [NAME] (QUEBEC) G2E 4A9 | 1501, RUE J.-F.-MARTEL | QUEBEC | ON | G2E 4A9 | G2E 4A91501, [NAME] (QUEBEC) G2E 4A91501, RUE J.-F.-MARTEL | 3916 | 40
M12345-3-082 |  | JACKSON MELYSSA | [PHONE] | CICAPLAST BAUME B5 40ML | LAWTON'S DRUG #2561 | 20 SILVER FOX AVE. UNIT 1 | NEW MINAS | NS | B4N 0C9 | B4N 0C9LAWTON'S DRUG #256120 SILVER FOX AVE. UNIT 1 | 3916 | 82
M12345-3-082 |  | GARDEN KAREN | [PHONE] | TOLERIANE SENSITIVE TINTED - MEDIUM | LAWTON'S DRUG #2561 | 20 SILVER FOX AVE. UNIT 1 | NEW MINAS | NS | B4N 0C9 | B4N 0C9LAWTON'S DRUG #256120 SILVER FOX AVE. UNIT 1 | 3916 | 82
M12345-3-082 |  | GARDEN KAREN | [PHONE] | PURETE THERMALE FRESH GEL CLEANSER 200ML | LAWTON'S DRUG #2561 | 20 SILVER FOX AVE. UNIT 1 | NEW MINAS | NS | B4N 0C9 | B4N 0C9LAWTON'S DRUG #256120 SILVER FOX AVE. UNIT 1 | 3916 | 82
M12345-3-083 |  | POIRIER ANGELIQUE | MB180400 | LIFTACTIV SPECIALIST PEPTIDE-C AMPOULES | PHCIE J.COUTU #274 | 200 RUE FUSEY | CAP-DE-LA-MADELEINE | QC | G8T 2V8 | G8T 2V8PHCIE J.COUTU #274200 RUE FUSEY | 3916 | 83
M12345-3-083 |  | POIRIER ANGELIQUE | [PHONE] | PURETE THERMALE FRESH GEL CLEANSER 200ML | PHCIE J.COUTU #274 | 200 RUE FUSEY | CAP-DE-LA-MADELEINE | QC | G8T 2V8 | G8T 2V8PHCIE J.COUTU #274200 RUE FUSEY | 3916 | 83
M12345-3-083 |  | POIRIER ANGELIQUE | [PHONE] | IDEAL SOLEIL SPORT SPF60 | PHCIE J.COUTU #274 | 200 RUE FUSEY | CAP-DE-LA-MADELEINE | QC | G8T 2V8 | G8T 2V8PHCIE J.COUTU #274200 RUE FUSEY | 3916 | 83
M12345-4-117 |  | TRAN LESSARD LEA | [PHONE] | TOLERIANE SENSITIVE TINTED - MEDIUM | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-117 |  | TRAN LESSARD LEA | [PHONE] | [NAME] SPOT TREATMENT | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-117 |  | TAILLEUR CATHERINE | [PHONE] | LIFTACTIV SPECIALIST B3 SERUM - DARK SPOTS | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-117 |  | TAILLEUR CATHERINE | [PHONE] | NORMADERM PHYTOSOLUTIONS ANTI-ACNE CARE 50ML | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-118 |  | MARTINEAU VICKY | [PHONE] | [NAME] BORN IN ROMA YELLOW DREAM EDP: 50ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-4-118 |  | MARTINEAU VICKY | [PHONE] | [NAME] BORN IN ROMA EDP : 100ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-4-118 |  | MARTINEAU VICKY | [PHONE] | YSL LIBRE EDT : 50ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-4-118 |  | MARTINEAU VICKY | [PHONE] | LIPIKAR BAUME AP+M ECO-TUBE 200ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | TOLERIANE SENSITIVE TINTED - MEDIUM | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | IDEAL SOLEIL SPORT SPF60 | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | [NAME] SPOT TREATMENT | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | PURETE THERMALE FRESH GEL CLEANSER 200ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | MB279600 | OIL INFUSED MICELLAR WATER ULTRA 400ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | NORMADERM PHYTOSOLUTIONS ANTI-ACNE CARE 50ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | HYALU B5 SERUM 30ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
WHAT I WANT (ADD A MARKER AT THE END OF SAME KEYCODE
KEYCODE_IMPORTED | STOP_CODE | NAME | SKU | DESC | STORE | [NAME] | CITY | PROV | PC | UNIQUECODE | UNIQUECODE Count | SEQ
M12345-1-001 | * | SAVOIE ELLA | [PHONE] | LIFE PLANKTON ™ ELIXIR - REGENERATING & ANTI-AGING SERUM | SHOPPERS DRUG MART#0136 | 278 LACEWOOD DR | HALIFAX | NS | B3M 3N8 | B3M 3N8SHOPPERS DRUG MART#0136278 LACEWOOD DR | 3916 | 1
M12345-2-038 |  | PARE FREDERIQUE | LC677100 | LA VIE EST BELLE SOLEIL CRISTAL | UNPX #031286 COURVILLE PHARMA INC | 1100 AVE LARUE | COURVILLE | QC | [NAME] 6H4 | [NAME] #031286 COURVILLE PHARMA INC1100 AVE LARUE | 3916 | 38
M12345-2-038 | * | PARE FREDERIQUE | [NAME] | EFFACLAR ULTRA CONCENTRATED SERUM 30ML | UNPX #031286 COURVILLE PHARMA INC | 1100 AVE LARUE | COURVILLE | QC | [NAME] 6H4 | [NAME] #031286 COURVILLE PHARMA INC1100 AVE LARUE | 3916 | 38
M12345-2-039 |  | COTE EMMANUELLE | LC677100 | LA VIE EST BELLE SOLEIL CRISTAL | PHARMAPRIX #1927 | 835 BOUL .RENE-LEVESQUE O. | QUEBEC | QC | [NAME] | G1S 1T4PHARMAPRIX #1927835 BOUL .RENE-LEVESQUE O. | 3916 | 39
M12345-2-039 | * | COTE EMMANUELLE | [PHONE] | CICAPLAST BAUME B5 40ML | PHARMAPRIX #1927 | 835 BOUL .RENE-LEVESQUE O. | QUEBEC | QC | [NAME] | G1S 1T4PHARMAPRIX #1927835 BOUL .RENE-LEVESQUE O. | 3916 | 39
M12345-2-040 |  | D.-ROY SONIA | [PHONE] | L'ABSOLU ROUGE INTIMATTE - SHADE: 888 | 1501, [NAME] (QUEBEC) G2E 4A9 | 1501, RUE J.-F.-MARTEL | QUEBEC | ON | G2E 4A9 | G2E 4A91501, [NAME] (QUEBEC) G2E 4A91501, RUE J.-F.-MARTEL | 3916 | 40
M12345-2-040 | * | D.-ROY SONIA | [PHONE] | YSL ROUGE VOLUPTE SHINE OIL AND STICK - SHADE 84 RED CASSANDRE | 1501, [NAME] (QUEBEC) G2E 4A9 | 1501, RUE J.-F.-MARTEL | QUEBEC | ON | G2E 4A9 | G2E 4A91501, [NAME] (QUEBEC) G2E 4A91501, RUE J.-F.-MARTEL | 3916 | 40
M12345-3-082 |  | JACKSON MELYSSA | [PHONE] | CICAPLAST BAUME B5 40ML | LAWTON'S DRUG #2561 | 20 SILVER FOX AVE. UNIT 1 | NEW MINAS | NS | B4N 0C9 | B4N 0C9LAWTON'S DRUG #256120 SILVER FOX AVE. UNIT 1 | 3916 | 82
M12345-3-082 |  | GARDEN KAREN | [PHONE] | TOLERIANE SENSITIVE TINTED - MEDIUM | LAWTON'S DRUG #2561 | 20 SILVER FOX AVE. UNIT 1 | NEW MINAS | NS | B4N 0C9 | B4N 0C9LAWTON'S DRUG #256120 SILVER FOX AVE. UNIT 1 | 3916 | 82
M12345-3-082 | * | GARDEN KAREN | [PHONE] | PURETE THERMALE FRESH GEL CLEANSER 200ML | LAWTON'S DRUG #2561 | 20 SILVER FOX AVE. UNIT 1 | NEW MINAS | NS | B4N 0C9 | B4N 0C9LAWTON'S DRUG #256120 SILVER FOX AVE. UNIT 1 | 3916 | 82
M12345-3-083 |  | POIRIER ANGELIQUE | MB180400 | LIFTACTIV SPECIALIST PEPTIDE-C AMPOULES | PHCIE J.COUTU #274 | 200 RUE FUSEY | CAP-DE-LA-MADELEINE | QC | G8T 2V8 | G8T 2V8PHCIE J.COUTU #274200 RUE FUSEY | 3916 | 83
M12345-3-083 |  | POIRIER ANGELIQUE | [PHONE] | PURETE THERMALE FRESH GEL CLEANSER 200ML | PHCIE J.COUTU #274 | 200 RUE FUSEY | CAP-DE-LA-MADELEINE | QC | G8T 2V8 | G8T 2V8PHCIE J.COUTU #274200 RUE FUSEY | 3916 | 83
M12345-3-083 | * | POIRIER ANGELIQUE | [PHONE] | IDEAL SOLEIL SPORT SPF60 | PHCIE J.COUTU #274 | 200 RUE FUSEY | CAP-DE-LA-MADELEINE | QC | G8T 2V8 | G8T 2V8PHCIE J.COUTU #274200 RUE FUSEY | 3916 | 83
M12345-4-117 |  | TRAN LESSARD LEA | [PHONE] | TOLERIANE SENSITIVE TINTED - MEDIUM | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-117 |  | TRAN LESSARD LEA | [PHONE] | [NAME] SPOT TREATMENT | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-117 |  | TAILLEUR CATHERINE | [PHONE] | LIFTACTIV SPECIALIST B3 SERUM - DARK SPOTS | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-117 | * | TAILLEUR CATHERINE | [PHONE] | NORMADERM PHYTOSOLUTIONS ANTI-ACNE CARE 50ML | FAMILIPRIX #2256 | 1015, ROUTE PREVOST | [NAME] | QC | G0A 4E0 | G0A 4E0FAMILIPRIX #22561015, ROUTE PREVOST | 3916 | 117
M12345-4-118 |  | MARTINEAU VICKY | [PHONE] | [NAME] BORN IN ROMA YELLOW DREAM EDP: 50ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-4-118 |  | MARTINEAU VICKY | [PHONE] | [NAME] BORN IN ROMA EDP : 100ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-4-118 |  | MARTINEAU VICKY | [PHONE] | YSL LIBRE EDT : 50ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-4-118 | * | MARTINEAU VICKY | [PHONE] | LIPIKAR BAUME AP+M ECO-TUBE 200ML | PHCIE J.COUTU #304 | 167 RUE DUPONT | PONT-ROUGE | QC | G3H 1N7 | G3H 1N7PHCIE J.COUTU #304167 RUE DUPONT | 3916 | 118
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | TOLERIANE SENSITIVE TINTED - MEDIUM | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | IDEAL SOLEIL SPORT SPF60 | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | [NAME] SPOT TREATMENT | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | PURETE THERMALE FRESH GEL CLEANSER 200ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | MB279600 | OIL INFUSED MICELLAR WATER ULTRA 400ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 |  | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | NORMADERM PHYTOSOLUTIONS ANTI-ACNE CARE 50ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184
M12345-7-184 | * | CHAMBERLAND-GAGNON KATY-ANNE | [PHONE] | HYALU B5 SERUM 30ML | PHARMAPRIX #1926 | 4850 HENRI-BOURASSA, SUITE 100 | QUEBEC | QC | G1H 3A7 | G1H 3A7PHARMAPRIX #19264850 HENRI-BOURASSA, SUITE 100 | 3916 | 184