I am struggling with a grid that *looks like this*

Arrival City 1 | City 2 | City 3 | City 4
Departure
City 1
City 2
City 3
City 4

I need to populate this grid with ticket sale data from another sheet where I have departure and arrival in two different columns and Total amounts for that trip in 3rd column:- (looks like this)
Depart Arrive Total Amt
City 1 City 2 100
City 2 City 3 120
City 3 City 1 90

Kindly help me coming up with a formula to do the same. Thanks