Spreadsheet: 738215d1624901973-populating-fields-to-create-a-flat-file-gk-again
Sheet: Sheet1

UNIQUECODE | PHARMACIE | PROVINCE | ADDRESS | POSTAL CODE | PROVINCE | STORE CITY | DESTINATAIRE | Names - Area 1 | Names - Area 2 | Names - Area 3 | Names - Area 4 | Names - Area 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Item Code | Item
 | SHOPPERS DRUG MART#0428 | SK | #T035 - 2102-11TH AVE | S4P 3Y6 | SASKATCHEWAN | REGINA | DIZDARI LAURETA | AA•1|A•1|B | FF•1|A•1|B | KK•1|A•1|B | PP•1|A•1|B | UU•1|D•1|E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | A-Stuff
 | SHOPPERS DRUG MART#1240 | ON | 3366 YONGE ST. | M4N 2M7 | ONTARIO | TORONTO | DA SILVA CANDICE | BB•1|A•1|B | GG•1|A•1|B | LL•1|A•1|C•1|D | QQ•1|A•1|A•1|B•1|B | VV•1|A•1|B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | B-Stuff
 | SHOPPERS DRUG MART#0273 | BC | 15105 - 16TH AVE. | V4A 6G3 | BRITISH COLUMBIA | SURREY | DAVIDSON LESLIE | CC•1|A•1|B | HH•1|A•1|B | MM•1|A•1|B | RR•1|A•1|B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | C-Stuff
 | LONDON DRUGS #11 | BC | 5971 NO 3 ROAD | V6X 2E3 | BRITISH COLUMBIA | RICHMOND | HONG KIM | DD•1|A•1|B | II•1|A•1|B | NN•1|A•1|B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | D-Stuff
 | SHOPPERS DRUG MART#0856 | ON | 2251 LAWRENCE EAST | M1P 2P5 | ONTARIO | SCARBOROUGH | DIEP VY | EE•1|D•1|D•1|B•1|E | JJ•1|A•1|A•1|B•1|B | OO•1|A•1|A•1|B•1|B | TT•1|A•1|A•1|A•1|B•1|B•1|C•1|D | YY•1|F•1|C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | E-Stuff
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | F-Stuff
UNIQUECODE | PHARMACIE | PROVINCE | ADDRESS | POSTAL CODE | PROVINCE | STORE CITY | DESTINATAIRE | Names - Area 1 | Names - Area 2 | Names - Area 3 | Names - Area 4 | Names - Area 5 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | A2 Item 1 | A2 Item 2 | A2 Item 3 | A2 Item 4 | A2 Item 5 | A2 Item 6 | A3 Item 1 | A3 Item 2 | A3 Item 3 | A3 Item 4 | A3 Item 5 | A3 Item 6 | A4 Item 1 | A4 Item 2 | A4 Item 3 | A4 Item 4 | A4 Item 5 | A5 Item 1 | A5 Item 2 | A5 Item 3 | A5 Item 4 | A5 Item 5 | A5 Item 6
 | SHOPPERS DRUG MART#0428 | SK | #T035 - 2102-11TH AVE | S4P 3Y6 | SASKATCHEWAN | REGINA | DIZDARI LAURETA |  |  |  |  |  |  | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff |  |  |  |  | 1-D-Stuff | 1-E-Stuff
 | SHOPPERS DRUG MART#1240 | ON | 3366 YONGE ST. | M4N 2M7 | ONTARIO | TORONTO | DA SILVA CANDICE |  |  |  |  |  |  | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-C-Stuff | 1-D-Stuff |  |  |  | 2-A-Stuff | 2-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff
 | SHOPPERS DRUG MART#0273 | BC | 15105 - 16TH AVE. | V4A 6G3 | BRITISH COLUMBIA | SURREY | DAVIDSON LESLIE |  |  |  |  |  |  | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff
 | LONDON DRUGS #11 | BC | 5971 NO 3 ROAD | V6X 2E3 | BRITISH COLUMBIA | RICHMOND | HONG KIM |  |  |  |  |  |  | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff |  |  |  |  | 1-A-Stuff | 1-B-Stuff
 | SHOPPERS DRUG MART#0856 | ON | 2251 LAWRENCE EAST | M1P 2P5 | ONTARIO | SCARBOROUGH | DIEP VY |  |  |  |  |  |  | 1-B-Stuff | 1-E-Stuff |  |  |  | 2-A-Stuff | 2-B-Stuff |  |  |  |  | 2-A-Stuff | 2-B-Stuff |  |  |  |  | 3-A-Stuff | 2-B-Stuff | 1-C-Stuff | 1-D-Stuff |  |  | 1-F-Stuff | 1-C-Stuff