Why I want someone like you but not you - friendzone explained

Why do certain people befriend certain others?
Why do the friendzone exist?
Why are you unable to achieve a single friend or partner despite listening to what others say, 'put in time, effort, commitment, money, life, opportunities, change....'