This content has been marked as final. Show 2 replies
I'm attempting to visualise shipping routes over a large period with a large variety of cargo, and load ports. I also have different trade route information on a separate spreadsheet.
The issue I'm having is that I need the "load port" to link or use the set of coordinates for the routes. I have struggled in linking the sheets in order to achieve this. I have the chronology of the trade routes too, but do not know how to approach this.
What I have considered is using unique route names and matching them. I didn't have an issue, however, it shows the whole route as opposed to the point-by-point data. The route information is lat/ln in either minute by minute or a standardised 1km basis.
Any help or alternative solutions will be appreciated.
Thanks in advance