Absolutely, transitioning from pharmacy to consulting is doable, especially in healthcare consulting. I for example have worked with doctors who made the switch, which tells me its feasible.
Start by :
1. Researching which consulting firms either specialize in pharma (boutique firms) or have offices with a strong pharma presence. You can usually get a feel of this from their websites.
2. Networking : reach out to ex-pharmacists or healthcare professionals now in consulting (Linkedin can help in finding these people)
3. Prepare for interviews: as you don't come from a business background, invest some time and effort in interview prep, and showcasing what matters in your CV and cover letter. I would recommend working with a coach (don't hesitate to reach out to me for a discussion)