title: Join routes origin and destination to rows with unique ID
body: <p>I'm trying to make a flight route map for some European airports in Tableau. I have the data in this formate:</p>
  
  <p><a href="https://i.stack.imgur.com/si871.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/si871.png" alt="mydata"></a></p>
  
  <p>and want to have it in pairs, for example as here:
  <a href="https://i.stack.imgur.com/ldmeD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ldmeD.png" alt="data I want"></a></p>
  
  <p>I wanted to follow <a href="https://public.tableau.com/en-us/s/blog/2015/07/taking-path-function" rel="nofollow noreferrer">this</a> tutorial but as I have a Mac version of Tableau Desktop "Legacy Connector" option is not available. 
  I also found <a href="https://blog.databender.net/2016/02/20/new-features-better-solutions/" rel="nofollow noreferrer">this</a> link and was able to pivot the data but then in Tableau I still have origin and destination latitude and longitude. 
  Is there any way to get the desired format of data in Tableau or Excel adding also unique path id column?</p>
  
  <p>Thanks for helping! </p>