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:
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?
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 will really appreciate any help