Unexpected competence

What characters, whether from TV, movies, books, plays, or whatever, are usually bad at something, except for one time where they inexplicably display competence in what they’re doing?

A day or two ago the Futurama episode was on where Amy and Fry briefly dated. The part where Zoidberg told Frey he saved him with some quick surgery seemed out of character for Zoidberg. Here, he successfully attached Frey’s head to Amy’s body, and he managed to keep Fry’s body from bleeding to death and in good shape to reattach later. This in contrast to the running joke that he’s a terrible doctor and usually knows nothing about human anatomy (because, as explained in a recent episode his Ph.D. is in art history.)

So what other characters are out there that suddenly become competent at something they’re usually bad at?