Spreadsheet: 806650d1669454219-trying-to-modify-a-complex-formula-that-outputs-a-spilled-result-in-multiple-columns-sample-data-1-
Sheet: Main

Product Information (current formula output) |  |  |  |  |  |  | Product Information (desired formula output)
Generic Name | Strength | Dosage Form | DIN/PDIN/NPN |  | Route |  | Generic Name | Strength | Dosage Form | Route | DIN/PDIN/NPN
 |  |  | Marketed | Approved |  |  |  |  |  |  | Marketed | Approved
Diphenhydramine |  | Tablet | 02141728, 02017849, 02097583, 02229492, 02229960, 02239029, 02257548, 02348608, 02479710, 02246449, 02258994, 02249529, 02515849, 02245778, 02521512, 02431599, 02436930, 02508796 |  |  |  | Diphenhydramine | 25 mg | Tablet | Oral | 02141728, 02017849, 02097583, 02229492, 02229960, 02239029, 02257548, 02348608, 02479710 | 02246449, 02258994, 02249529, 02515849, 02245778, 02521512, 02431599, 02436930, 02508796 |  |  | 25 mg | Tablet | Oral | 2141728 2017849 2097583 2229492 2229960 2239029 2257548 2348608 2479710 | 2246449 2258994 2249529 2515849 2245778 2521512 2431599 2436930 2508796
Diphenhydramine | 25 mg | Capsule | 00757683, 02306352, 02383268, 02365685, 02304252, 02520745, 02411415 |  |  |  | Diphenhydramine | 25 mg | Capsule | Oral | 00757683, 02306352, 02383268, 02365685, 02304252 | 02520745, 02411415 |  | Diphenhydramine | 50 mg/mL | Liquid | Intramuscular | 2219336 596612 | #[NAME]!
Diphenhydramine | 25 mg | Strip | 02284170 |  |  |  | Diphenhydramine | 25 mg | Strip | Oral |  | 02284170 |  | Diphenhydramine | 50 mg/mL | Liquid | Intravenous | 2219336 596612 | #[NAME]!
Diphenhydramine | 50 mg/mL | Liquid | 02219336, 02219336, 00596612, 00596612 |  |  |  | Diphenhydramine | 50 mg/mL | Liquid | Intramuscular, [NAME] | 02219336, 00596612 |  |  | Diphenhydramine | 6.25 mg/5 mL | Solution | Oral | 2019698 2248858 2478242 | 2311232
Diphenhydramine | 50 mg/mL | Solution | 02369567, 02369567 |  |  |  | Diphenhydramine | 50 mg/mL | Solution | Intramuscular, [NAME] | 02369567 |  |  | Diphenhydramine | 50 mg | Tablet | Oral | 1934414 1991086 1946986 2097575 2229959 2230398 2230485 [PHONE] 2239138 2257556 2490943 2478757 2498952 2470144 2409259 | 2246450 2263882 2456303 2515830 2532484
Diphenhydramine | 6.25 mg/5 mL | Solution | 02019698, 02248858, 02478242, 02311232 |  |  |  | Diphenhydramine | 6.25 mg/5 mL | Solution | Oral | 02019698, 02248858, 02478242 | 02311232 |  | Diphenhydramine | 50 mg | Capsule | Oral | 2061597 757691 [PHONE] 2238644 2244203 2409224 2321270 | 2361256 2447827 2247659 2270900 2318849 2483122 2491850
Diphenhydramine | 6.25 mg/5 mL | Syrup | 02368374 |  |  |  | Diphenhydramine | 6.25 mg/5 mL | Syrup | Oral |  | 02368374 |  | Diphenhydramine | 25 mg | Capsule | Oral | [PHONE] 2383268 2365685 2304252 | 2520745 2411415
Diphenhydramine | 50 mg | Tablet | 01934414, 01991086, 01946986, 02097575, 02229959, 02230398, 02230485, 00583332, 02237789, 02239138, 02257556, 02490943, 02478757, 02498952, 02470144, 02409259, 02246450, 02263882, 02456303, 02515830, 02532484 |  |  |  | Diphenhydramine | 50 mg | Tablet | Oral | 01934414, 01991086, 01946986, 02097575, 02229959, 02230398, 02230485, 00583332, 02237789, 02239138, 02257556, 02490943, 02478757, 02498952, 02470144, 02409259 | 02246450, 02263882, 02456303, 02515830, 02532484 |  | Diphenhydramine | 12.5 mg | Tablet (Chewable) | Oral | 2061287 | 2312352
Diphenhydramine | 50 mg | Capsule | 02061597, 00757691, 00489867, 02237169, 02238644, 02244203, 02409224, 02321270, 02361256, 02447827, 02247659, 02270900, 02318849, 02483122, 02491850 |  |  |  | Diphenhydramine | 50 mg | Capsule | Oral | 02061597, 00757691, 00489867,  02237169, 02238644, 02244203, 02409224, 02321270 | 02361256, 02447827, 02247659, 02270900, 02318849, 02483122, 02491850 |  | Diphenhydramine | 12.5 mg/5 mL | Solution | Oral | 2019736 2465108 | #[NAME]!
Diphenhydramine | 12.5 mg | Tablet | 02247762 |  |  |  | Diphenhydramine | 12.5 mg | Tablet | Oral |  | 02247762 |  | Diphenhydramine | 2% | Cream | Topical | 2247560 | 2401932 2354578
Diphenhydramine | 12.5 mg | Tablet (Chewable) | 02061287, 02312352 |  |  |  | Diphenhydramine | 12.5 mg | Tablet (Chewable) | Oral | 02061287 | 02312352 |  | Diphenhydramine | 12.5 mg/5 mL | Liquid | Oral | 2248859 | #[NAME]!
Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | 02505649 |  |  |  | Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | Oral | 02505649 |  |  | Diphenhydramine | 12.5 mg/5 mL | Elixir | Oral | 2298503 | 2311240
Diphenhydramine | 12.5 mg/5 mL | Liquid | 02248859 |  |  |  | Diphenhydramine | 12.5 mg/5 mL | Liquid | Oral | 02248859 |  |  | Diphenhydramine | 50 mg/mL | Solution | Intramuscular | 2369567 | #[NAME]!
Diphenhydramine | 12.5 mg/5 mL | Solution | 02019736, 02465108 |  |  |  | Diphenhydramine | 12.5 mg/5 mL | Solution | Oral | 02019736, 02465108 |  |  | Diphenhydramine | 50 mg/mL | Solution | Intravenous | 2369567 | #[NAME]!
Diphenhydramine | 12.5 mg/5 mL | Elixir | 02298503, 02311240 |  |  |  | Diphenhydramine | 12.5 mg/5 mL | Elixir | Oral | 02298503 | 02311240 |  | Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | Oral | 2505649 | #[NAME]!
Diphenhydramine | 2% | Cream | 02247560, 02401932, 02354578 |  |  |  | Diphenhydramine | 2% | Cream | Topical | 02247560 | 02401932, 02354578 |  | Diphenhydramine | 50 mg/30 mL | Liquid | Oral | 2419769 | #[NAME]!
Diphenhydramine | 50 mg/30 mL | Liquid | 02419769 |  |  |  | Diphenhydramine | 50 mg/30 mL | Liquid | Oral | 02419769 |  |  | Diphenhydramine | 50 mg/30 mL | Solution | Oral | 2427427 2432129 2474867 2464683 | #[NAME]!
Diphenhydramine | 50 mg/30 mL | Solution | 02427427, 02432129, 02474867, 02464683 |  |  |  | Diphenhydramine | 50 mg/30 mL | Solution | Oral | 02427427, 02432129, 02474867, 02464683 |  |  | DIPHENHYDRAMINE | 6.25 mg/5 mL | Syrup | Oral | #[NAME]! | 2368374
Diphenhydramine | 2%/w/w | Cream | 02321076 |  |  |  | Diphenhydramine | 2%/w/w | Cream | Topical |  | 02321076 |  | DIPHENHYDRAMINE | 2%/w/w | Cream | Topical | #[NAME]! | 2321076
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DIPHENHYDRAMINE | 25 mg | Strip | Oral | #[NAME]! | 2284170
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DIPHENHYDRAMINE | 12.5 mg | Tablet | Oral | #[NAME]! | 2247762