I was that guy, except I had loads of ideas. I even created them, includidng the first content management system ever, which I designed and was in use by our web development clients in 1994, for a company I owned.

Sadly, I had no freaking idea how to market, run a business, get funding, get mass customers, or anything else of use. Eventually I figured enough of it out to launch a profitable startup, but it took 15 years. lol.

I think the most important thing to success you need is a successful mentor, who is doing something similar to what you want to achieve. The more the better. That was the major turning point for me.