Tableau reshaping a row with origin/destination into two separate origin and destination rows
<p>I am trying to turn data that looks like this:    </p>

<pre><code>DeparturePort   DepartureLatitude   DepartureLongitude  ArrivalPort    ArrivalLatitude  ArrivalLongitude  Data
ABERDEEN        46.983              -123.817            BURNTISLAND    56.0500          -3.233            100
ABERDEEN        46.983              -123.817            CROMARTY       57.6833          -4.033            200
ABERDEEN        46.983              -123.817            IMMINGHAM      53.6333          -0.200            300
</code></pre>

<p>Into something that looks like this: (to eventually plot path lines on a map)</p>

<pre><code>Port         Latitude   Longitude   Type         Path                   Data
ABERDEEN     46.983     -123.817    Departure    ABERDEEN-BURNTISLAND   100
BURNTISLAND  56.0500    -3.233      Arrival      ABERDEEN-BURNTISLAND   100
ABERDEEN     46.983     -123.817    Departure    ABERDEEN-CROMARTY      200
CROMARTY     57.6833    -4.033      Arrival      ABERDEEN-CROMARTY      200
ABERDEEN     46.983     -123.817    Departure    ABERDEEN-IMMINGHAM     300
IMMINGHAM    53.6333    -0.200      Arrival      ABERDEEN-IMMINGHAM     300 
</code></pre>

<p>I've tried using a pivots but it never seems to look very close to what I want. Is there another type of reshaping I should be using? </p>