Honestly, I think it's genetic. A bunch of my dad's relatives are also like this, and from stories I've heard of him, I think my grandfather was too. If you're working with someone like this, it's best just to find some way to use his talents while keeping his weaknesses from being too disruptive (eg. send him off prototyping this pie-in-the-sky idea while everyone else handles the day-to-day minutiae of getting stuff done). If you are this person, find a profession where the strengths matter and the weaknesses don't. Like research, or tech startups.
It's possible to overcome these personality traits with enough effort, but the good goes away with the bad. I found my concentration plummeted as I became more socially adept, as did my ability to come up with crazy-off-the-wall solutions that nobody else thought of. And I notice a big, big performance penalty from multitasking, moreso than most people.