Calculating text totals across multiple columns - need help!

I have a rather large report that pulls top five medications in a seperate column. The total number of possible medications is very long. What I would like to do is count (and display) the total number of times the medicaiton appears across all 5 columns. I am not sure that I can unpivot the data because they are linked to patient ID numbers and a bunch of other metrics.

                  Med 1     Med 2    Med 3    Med 4   Med 5

Patient 1       c             a        

Patient 1       b              c             d

Patient 2       a              b              c            d             e

Patient 2       c              d             b            d             e     

Patient 3        b             c              d      

Would like to be able to write a measure (or something) to be able to simply show the following (keep in mind there are a lot more medications than what I put in my example using letters).

a = 2 

b =4

c = 5

d = 5

e = e

Thanks in advance!