CLAASSJA2421
07-27-2015, 12:27 AM
Hi anyone,
I have a spreadsheet that pulls data from various other files and gives a report in of out of stock items at different clinics in one cell as below:
3
ATTERIDGEVILLE
July1E
Abacavir (ABC) (Aspen Abacavir) 300mg Tablet; 60 PT Ready Pack [PO]\Amethocaine 1% Cream; 25 g [TOP]\Benzoyl Peroxide 5% Gel; 40 g [TOP]\Bismuth Subgallate Co 22.5/8,75/8,75/12,5/ Ointment; 25 g [TOP]\Emulsifying (UE) BP Ointment; 500 g [TOP]\Lopinavir / Ritonavir (LPV/RTV) (Aluvia) 200/50mg Tablet; 120 PT Ready Pack [PO]
3
DANVILLE
July1E
2
DOORNPOORT
July1E
5
EAST LYNNE
July1E
3
FF RIBEIRO
July1E
3
FOLANG
July1E
3
GAZANKULU
July1E
3
HERCULES
July1E
Allopurinol 100mg Tablet; 28 PT Ready Pack [PO]\Beclomethasone Diproprionate 200mcg Inhaler; 200 Dose\Bismuth Subgallate Co 22.5/8,75/8,75/12,5/ Ointment; 25 g [TOP]\Calcium Carbonate, Glycine (Chewable) 420mg/180mg Tablet; 56 PT Ready Pack [PO]\Chlorpheniramine Maleate 4mg Tablet; 10 PT Ready Pack [PO]\Ferrous Sulphate Co (Sugar Coated) 200mg Tablet; 28 PT Ready Pack [PO]\Folic Acid 5mg Tablet; 28 PT Ready Pack [PO]\Ipratropium Bromide (Aerosol Oral Inhalation Metered Dose Complete Unit) 40mcg/dose Inhaler; 300 Dose [INH]\Lamivudine (3TC) (Cipla Lamivudine) 150mg Tablet; 60 PT Ready Pack [PO]\Mebendazole 100mg/5ml Suspension; 30 ml [PO]\Paracetamol 500mg Tablet; 20 PT Ready Pack [PO]\Sterile Water For Irrigation, Pour Bottle BP NA; 1000 ml [DIS]\Vaccine: BCG Intradermal, with Diluent BP Vial; 20 Dose [INJ]\Vaccine: Hepatitis B Peadiatric Vial; 10 Dose [INJ]\Zidovudine (AZT) (Retrovir) 50mg/5ml Syrup; 200 mL [PO]\Zinc Picolinate, Selenium & Vit C 200ml 1 Liquid, Internal; 200 ml [PO]
I have used "\" as the separator. I need to transpose theses columns into a new sheet listing all the items below each clinic, each item in a new line. Will this be possible?
I will really appreciate any help
I have a spreadsheet that pulls data from various other files and gives a report in of out of stock items at different clinics in one cell as below:
3
ATTERIDGEVILLE
July1E
Abacavir (ABC) (Aspen Abacavir) 300mg Tablet; 60 PT Ready Pack [PO]\Amethocaine 1% Cream; 25 g [TOP]\Benzoyl Peroxide 5% Gel; 40 g [TOP]\Bismuth Subgallate Co 22.5/8,75/8,75/12,5/ Ointment; 25 g [TOP]\Emulsifying (UE) BP Ointment; 500 g [TOP]\Lopinavir / Ritonavir (LPV/RTV) (Aluvia) 200/50mg Tablet; 120 PT Ready Pack [PO]
3
DANVILLE
July1E
2
DOORNPOORT
July1E
5
EAST LYNNE
July1E
3
FF RIBEIRO
July1E
3
FOLANG
July1E
3
GAZANKULU
July1E
3
HERCULES
July1E
Allopurinol 100mg Tablet; 28 PT Ready Pack [PO]\Beclomethasone Diproprionate 200mcg Inhaler; 200 Dose\Bismuth Subgallate Co 22.5/8,75/8,75/12,5/ Ointment; 25 g [TOP]\Calcium Carbonate, Glycine (Chewable) 420mg/180mg Tablet; 56 PT Ready Pack [PO]\Chlorpheniramine Maleate 4mg Tablet; 10 PT Ready Pack [PO]\Ferrous Sulphate Co (Sugar Coated) 200mg Tablet; 28 PT Ready Pack [PO]\Folic Acid 5mg Tablet; 28 PT Ready Pack [PO]\Ipratropium Bromide (Aerosol Oral Inhalation Metered Dose Complete Unit) 40mcg/dose Inhaler; 300 Dose [INH]\Lamivudine (3TC) (Cipla Lamivudine) 150mg Tablet; 60 PT Ready Pack [PO]\Mebendazole 100mg/5ml Suspension; 30 ml [PO]\Paracetamol 500mg Tablet; 20 PT Ready Pack [PO]\Sterile Water For Irrigation, Pour Bottle BP NA; 1000 ml [DIS]\Vaccine: BCG Intradermal, with Diluent BP Vial; 20 Dose [INJ]\Vaccine: Hepatitis B Peadiatric Vial; 10 Dose [INJ]\Zidovudine (AZT) (Retrovir) 50mg/5ml Syrup; 200 mL [PO]\Zinc Picolinate, Selenium & Vit C 200ml 1 Liquid, Internal; 200 ml [PO]
I have used "\" as the separator. I need to transpose theses columns into a new sheet listing all the items below each clinic, each item in a new line. Will this be possible?
I will really appreciate any help