Good luck with that. I've been in a similar position myself, and it's not easy, specially when you value the person's friendship and wish they would do what it takes to make it work. But ultimately, there is only so much you can do; you can lead a horse to water, but you can't make him drink. I hope it works out for both of you.