Spreadsheet: 806641d1669447405-trying-to-modify-a-complex-formula-that-outputs-a-spilled-result-in-multiple-columns-sample-data
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
Diphenhydramine | 25 mg | Capsule | 00757683, 02306352, 02383268, 02365685, 02304252, 02520745, 02411415 |  |  |  | Diphenhydramine | 25 mg | Capsule | Oral | 00757683, 02306352, 02383268, 02365685, 02304252 | 02520745, 02411415
Diphenhydramine | 25 mg | Strip | 02284170 |  |  |  | Diphenhydramine | 25 mg | Strip | Oral |  | 02284170
Diphenhydramine | 50 mg/mL | Liquid | 02219336, 02219336, 00596612, 00596612 |  |  |  | Diphenhydramine | 50 mg/mL | Liquid | Intramuscular, [NAME] | 02219336, 00596612
Diphenhydramine | 50 mg/mL | Solution | 02369567, 02369567 |  |  |  | Diphenhydramine | 50 mg/mL | Solution | Intramuscular, [NAME] | 02369567
Diphenhydramine | 6.25 mg/5 mL | Solution | 02019698, 02248858, 02478242, 02311232 |  |  |  | Diphenhydramine | 6.25 mg/5 mL | Solution | Oral | 02019698, 02248858, 02478242 | 02311232
Diphenhydramine | 6.25 mg/5 mL | Syrup | 02368374 |  |  |  | Diphenhydramine | 6.25 mg/5 mL | Syrup | Oral |  | 02368374
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 | 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 | Tablet | 02247762 |  |  |  | Diphenhydramine | 12.5 mg | Tablet | Oral |  | 02247762
Diphenhydramine | 12.5 mg | Tablet (Chewable) | 02061287, 02312352 |  |  |  | Diphenhydramine | 12.5 mg | Tablet (Chewable) | Oral | 02061287 | 02312352
Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | 02505649 |  |  |  | Diphenhydramine | 12.5 mg | Tablet (Orally Disintegrating) | Oral | 02505649
Diphenhydramine | 12.5 mg/5 mL | Liquid | 02248859 |  |  |  | Diphenhydramine | 12.5 mg/5 mL | Liquid | Oral | 02248859
Diphenhydramine | 12.5 mg/5 mL | Solution | 02019736, 02465108 |  |  |  | Diphenhydramine | 12.5 mg/5 mL | Solution | Oral | 02019736, 02465108
Diphenhydramine | 12.5 mg/5 mL | Elixir | 02298503, 02311240 |  |  |  | Diphenhydramine | 12.5 mg/5 mL | Elixir | Oral | 02298503 | 02311240
Diphenhydramine | 2% | Cream | 02247560, 02401932, 02354578 |  |  |  | Diphenhydramine | 2% | Cream | Topical | 02247560 | 02401932, 02354578
Diphenhydramine | 50 mg/30 mL | Liquid | 02419769 |  |  |  | Diphenhydramine | 50 mg/30 mL | Liquid | Oral | 02419769
Diphenhydramine | 50 mg/30 mL | Solution | 02427427, 02432129, 02474867, 02464683 |  |  |  | Diphenhydramine | 50 mg/30 mL | Solution | Oral | 02427427, 02432129, 02474867, 02464683
Diphenhydramine | 2%/w/w | Cream | 02321076 |  |  |  | Diphenhydramine | 2%/w/w | Cream | Topical |  | 02321076