Pfizer has become the most reputable pharma company for cancer patient groups, knocking Roche out of the top spot.