Yet again, I know what I want to do, but have no idea how to to it.

Say I've got
Name Location Date Hours
Fred Town1 1-Jan 8
Fred Town2 2-Jan 8
Fred Town1 3-Jan 10
Joe Town1 1-Jan 12
Joe Town2 2-Jan 2
etc.

How can I group these on location and Name to get the result:
Fred Town1 Jan 18
Fred Town2 Jan 8
Joe Town1 Jan 12
Joe Town2 Jan 2

Any suggestions?
TIA
J