well your information is fundamentally correctly there and that's a good starting point. essentially you are trying to manipulate the display, not the data - - and it is surprisingly difficult for what seems like a simple thing to make that 'stacked' time info (which is the native database organization) into the side-by-side excel look.
Consider the patient with an hourly dosage - you would need 24 side-by-side fields! If this is potentially possible - then you could run out of paper in the left-to-right layout concept which may be a deal breaker too. In which case one should pause to consider your original layout.
So there are 2 approaches; one is to investigate the crosstab feature. that fundamentally gives you what you seek as the name implies.
the other approach to consider is the grouping feature in Reports which will not give you what you seek but is simple and may suffice. it would give you:
Dicyclomine, 10mg. 3 x daily 10mg AM
with grouping you can put the common info into the group header and avoid eye fatique and allow the variable data to stand out. very common.