Train ticket

After buying my train ticket last night and paying for it , it now looks as though I am no longer going for the days to Scotland like I planned. I now have a train ticket that can not be used and I am a little upset about it because I really don't have money to chuck away like that. I am going to put it on eBay but it is very doubtful that there will be anyone that wants to travel from Blackburn to Glasgow on the 13th August.
The reason that I am no longer going is because my friend arranged a weekend away to celebrate a friends birthday just before he went to Ireland this month and was told today that it's booked for the same weekend that I was meant to go up there. As he has paid £90 towards it he is going to go and I am stuck now with this ticket. If I only knew last night then the ticket wouldn't have been bought as it was only bought last night.
All is not lost though as I will be going away that weekend no matter what. I just need to think of someone else to go and visit and someone's name shoots straight to my mind. So I'm hoping to go and visit them instead as I will have so much fun with them and it'll be so great to see them as I am missing them. If it isn't at all possible to go and visit them I'm sure that I will find someone to go and visit instead but I do know where I want to go and I will NOT be buying another train ticket until I am 100% sure this time.
I did tell my friend that seen as he made the mistake and that myself and him had made our arrangements months ago that he really should try to get out of his weekend away but he's not even willing to try because he is worried that he will lose his deposit. But the thing is he's on 5 times the amount I'm on a year. I thought that he could pay me back for the money I have lost from the ticket but he's not even willing to do that.