Merging active-space and renormalized coupled-cluster methods via the CC(P;Q) formalism, with applications to chemical reaction profiles and singlet-triplet gaps