I was the super stereotypical scatter-brained ENFP with all sorts of craziness and ideas and inspiration sparking from me 24/7 but learning to do hard, seemingly meaningless, trivial, etc. work was IM-POS-SI-BLE. If I don't want to do it, it ain't gonna happen. Parents, teachers, bosses have tried and failed. I'm not proud of this fact by a long shot. But I accept it's part of my character and work with it. Intractibility can actually be a great tool and gift sometimes -- just not when you need to be grown person and pay bills, etc.
And that "whoa, look at me, I'm so scatter-brained I'm a hopeless mess!" can be cute when you're 6 or maybe even 16, but once you hit 'Adulthood' (capital 'A') it's NOT cute anymore.
I could always be consistent and actually do a pretty good job on a project basis where I was motivated to start something -- like organizing a panel for a conference or a girls basketball team (both which I have done before). But in terms of administration and the long haul? Pure torture. It was really hard for me to be consistent even in practicing music, going to class regularly, making it through McJob after McJob. Eesh.
As I've gotten older, I've gotten better and better and make a passably good adult and can even fake some coworkers into thinking I'm a 'J'.
But really, the only way I found to push through it and realize ideas and goals is to just suck it up and do it. I have no sympathy for myself, no coddling, no prancing unicorns or hugs. I guess I let my shadow ISTJ go to TOWN, son! LOL.
There is no magic pill or button to make things happen for you, nobody who will magically come in at 0 hour and do the work for you or make it better. You might not even have any friends or supporters. It's you. Versus reality.
So if you want it, do it.
Honestly, that's helped me out a lot!
And after the first few painful torturous steps it gets easier and easier. Especially after your hard work and consistency actually have pay offs. Really, that's the biggest motivator -- knowing that doing the work actually gets you results. Like with any habit (for better or worse) the more you do it, the more it becomes ingrained in you and natural.
The pendulum keeps swinging to extremes but as you work on yourself and develop, it evens out. At least for me, says the ENFP.