Every scenario is different, in this case you've already had the moment where it could have progressed more from the 'friendzone'. There is always the possibility of getting out of it again, but its going to be really tough and not really beneficial to your progress as a person. The best and most beneficial solution here is as it has been stated to move on, you need to be able to say to yourself that this route isn't going to work and find gratification elsewhere. I'm not saying its easy, I still struggle with it myself but as an observer it is actually easier said than done. But it doesn't stop it being right.