90% of the time all you need to do when someone is moaning to you about something/sad about something is say "s**t, I'm sorry, that sucks". That's all. Seriously.