Getting Pivot Table to Recognize Multiple Values in a Cell

I document infections in a spreadsheet and some patients take more than 1 antibiotic. I need to find a way to get the pivot table to recognize all of the medications in the column, including those cells with multiple values, and individuals.



I attached a brief version of the file and a picture of the Pivot Table I'm trying to create... I know that the pivot table can't automatically do this, but there has to be a roundabout way to do this. I've tried some things that delineated the cell, but then my other pivot tables will be inaccurate because it will show more values that there actually is...