College change help?

I want to go to a certain college the same one as someone I know but they don't offer the course I need what sub can change this