Name | disp date | lloyds | homecare | paracetamol | aspirin | omeprazole | iron tabs | sudafed |
Patient A | 01-09-17 | lloyds | 50 | 50 | ||||
Patient B | 03-09-17 | homecare | 20 | 23 | 6 | |||
Patient C | 03-09-17 | homecare | 100 | 56 | 30 | |||
Patient D | 10-10-17 | lloyds | 84 | |||||
Name | Disp Date | Pharmacy | Drug | Quantity | ||||
Patient A | 01-09-17 | lloyds | paracetamol | 50 | ||||
Patient A | 01-09-17 | paracetamol | 50 | |||||
Patient B | 03-09-17 | homecare | aspirin | 20 | ||||
Patient B | 03-09-17 | omeprazole | 23 | |||||
Patient B | 03-09-17 | sudafed | 6 | |||||
Patient C | 03-09-17 | homecare | paracetamol | 100 | ||||
Patient C | 03-09-17 | omeprazole | 56 | |||||
Patient C | 03-09-17 | sudafed | 30 | |||||
Patient D | 10-10-17 | lloyds | aspirin | 84 |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col span="2"><col><col><col><col></colgroup><tbody></tbody>
<colgroup><col><col><col><col span="2"><col><col><col><col></colgroup><tbody></tbody>
At the top is a table where each patient has multiple drugs listed with the quantity supplied for each. I need to be able to redisplay each drug as a separate row, also detailing which patient / date and only selecting the pharmacy against their 1st item.
I have found some formulas online, but they do not work if a quantity is repeated in the same row as per patient A.
Any help would be greatly appreciated.