I am sorry to say i have dealt with an awful lot of loss of life in my shortish time around, all ages, family and friends, i can only say one day the tears will be replaced with smiles and laughter with the memory of a great friend which i am sure is how Andrew would want it
Just to add, whilst it may be a massive struggle to face work, its great to fill your head with other stuff so make the effort to go, even though it wont seem like it, you will be distracted by it.