Excel to return all possible combination of data

[akhil.nair]

I have a set of Data as per below :

Column A : Origin Country
Column B : Destination Country
Column C : export rate (doesnt mean actual rate here but an index)


Now i have about 100 country names in column A and the same 100 in column B.
different values for each lane export rate.

Example China to Russia export rate is 50 but China to russia import rate is 10

I need excel to calculate all the possibilities between all countries in column A and Column B and return the export rate for each depending on the combination.

The end aim is to be able to select which combination has the lowest export rate (index) and use that

Is this possible ?

 

[BobUmlas]

Easy pivot table.
origin as row labels, destination as column labels, export rate as values.