views for nodes with multiple locations

Hi,

I've enabled a custom node to have 2 locations, with each location corresponding to an end point of a route (i.e. start, destination). I want to clone the location views table to display these routes. With the default location table view, I get two rows for each route node - one row for the start location, the other for the destination.

I want to change this so I can have one row per route node that contains both location addresses. I've played around with the views interface and am at a loss as to how to do this. Does anyone have any suggestions?

Cheers,
Stella