Spreadsheet: 737843d1624624912-populating-fields-to-create-a-flat-file-sample
Sheet: Sheet1

UNIQUECODE | PHARMACIE | NAME1 | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7 | NAME8 | NAME9 | PROVINCE | ADDRESS | POSTAL CODE | PROVINCE | STORE CITY | DESTINATAIRE
 | SHOPPERS DRUG MART#0428 | DIZDARI LAURETA•1|A•1|B | [NAME] | KARY MICHELLE•1|A•1|B | LAMBERT PATTI•1|A•1|B | WARD KAYLA•1|A•1|B |  |  |  |  | SK | #T035 - 2102-11TH AVE | S4P 3Y6 | SASKATCHEWAN | REGINA | DIZDARI LAURETA
 | SHOPPERS DRUG MART#1240 | DA SILVA CANDICE•1|A•1|B | FARAHMAND-ZADEH NASTARAN•1|A•1|B | GOLMOHAMMADI MAHSA•1|A•1|C•1|D | NOBAKHT TANIN•1|A•1|A•1|B•1|B | SHAKIBAEI SAMIN•1|A•1|B | SHOWEYLI FATIMA•1|A•1|B |  |  |  | ON | 3366 YONGE ST. | M4N 2M7 | ONTARIO | TORONTO | DA SILVA CANDICE
 | SHOPPERS DRUG MART#0273 | DAVIDSON LESLIE•1|A•1|B | ROBB TERRI•1|A•1|B | SHTOGRINA IULIIA•1|A•1|B | SINGH SUZANNE•1|A•1|B |  |  |  |  |  | BC | 15105 - 16TH AVE. | V4A 6G3 | BRITISH COLUMBIA | SURREY | DAVIDSON LESLIE
 | LONDON DRUGS #11 | HONG KIM•1|A•1|B | LIU LI•1|A•1|B | SETO DANIELLE•1|A•1|B | SU SUSAN•1|A•1|B |  |  |  |  |  | BC | 5971 NO 3 ROAD | V6X 2E3 | BRITISH COLUMBIA | RICHMOND | HONG KIM
 | SHOPPERS DRUG MART#0856 | DIEP VY•1|A•1|A•1|B•1|D | HATZIS SHERI SDM #856•1|A•1|A•1|B•1|B | MATA JANEEN•1|A•1|A•1|B•1|B | THURAIRAJAH REGA•1|A•1|A•1|A•1|B•1|B•1|C•1|D |  |  |  |  |  | ON | 2251 LAWRENCE EAST | M1P 2P5 | ONTARIO | SCARBOROUGH | DIEP VY
CODE | [NAME]
A | LIFE PLANKTON ELIXIR 50ML
B | BT EYES 15ML
C | BIOTH BT RED ALGAE NT P50 TEST
D | LP BODY MILK T75ML TE
UNIQUECODE | PHARMACIE | NAME1 | NAME2 | NAME3 | NAME4 | NAME5 | NAME6 | NAME7 | NAME8 | NAME9 | NAME1_ITEM1 | NAME1_ITEM2 | [NAME] | NAME1_ITEM4 | NAME2_ITEM1 | NAME2_ITEM2 | [NAME] | NAME2_ITEM4 | NAME3_ITEM1 | NAME3_ITEM2 | [NAME] | NAME3_ITEM4 | NAME4_ITEM1 | NAME4_ITEM2 | [NAME] | NAME4_ITEM4 | NAME5_ITEM1 | NAME5_ITEM2 | NAME5_ITEM3 | NAME5_ITEM4 | NAME6_ITEM1 | NAME6_ITEM2 | NAME6_ITEM3 | NAME6_ITEM4 | PROVINCE | ADDRESS | POSTAL CODE | PROVINCE | STORE CITY | DESTINATAIRE
 | SHOPPERS DRUG MART#0428 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  |  |  |  |  |  |  |  |  | SK | #T035 - 2102-11TH AVE | S4P 3Y6 | SASKATCHEWAN | REGINA | DIZDARI LAURETA
 | SHOPPERS DRUG MART#1240 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BIOTH BT RED ALGAE NT P50 TEST | 1-LP BODY MILK T75ML TE |  | 2-LIFE PLANKTON ELIXIR 50ML | 2-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | ON | 3366 YONGE ST. | M4N 2M7 | ONTARIO | TORONTO | DA SILVA CANDICE
 | SHOPPERS DRUG MART#0273 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  |  |  |  |  |  |  |  |  | BC | 15105 - 16TH AVE. | V4A 6G3 | BRITISH COLUMBIA | SURREY | DAVIDSON LESLIE
 | LONDON DRUGS #11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  | 1-LIFE PLANKTON ELIXIR 50ML | 1-BT EYES 15ML |  |  |  |  |  |  |  |  |  |  | BC | 5971 NO 3 ROAD | V6X 2E3 | BRITISH COLUMBIA | RICHMOND | HONG KIM
 | SHOPPERS DRUG MART#0856 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-LIFE PLANKTON ELIXIR 50ML | 2-BT EYES 15ML |  |  | 2-LIFE PLANKTON ELIXIR 50ML | 2-BT EYES 15ML |  |  | 3-LIFE PLANKTON ELIXIR 50ML | 2-BT EYES 15ML | 1-BIOTH BT RED ALGAE NT P50 TEST | 1-LP BODY MILK T75ML TE |  |  |  |  |  |  |  |  | ON | 2251 LAWRENCE EAST | M1P 2P5 | ONTARIO | SCARBOROUGH | DIEP VY