Formula to combine 2 columns

Hello,

I'm total newbie regarding excel formula. I have the following table:

A	B	C
Andorra	AD
Belgium	BE
Bulgaria	BG
Cyprus	CY
Denmark	DK
England	EN
Finland	FI
France	FR
Germany	DE
Greece	GR
Italy	IT
Netherlands	NL
Poland	PL
Portugal	PT
Spain	ES
Sweden	SE

I'm trying to write a formula to generate a matrix representing all the possible travels : Travel from A to A, from A to B, from B to A, and from B to B. The only restriction is not to travel from a country to itself.

At the end I want to generate the result in a single column C, like this :

Travel from Belgium to Andorra
Travel from Belgium to England
Travel from Belgium to France
Travel from Belgium to Germany
Travel from Belgium to Netherlands
Travel from Belgium to Italy
Travel from Belgium to Spain
Travel from England to Belgium
Travel from England to France
Travel from England to Germany
Travel from England to Netherlands
Travel from England to Italy
Travel from England to Spain
etc
Travel from Belgium to AD
Travel from Belgium to EN
Travel from Belgium to FR
Travel from Belgium to DE
Travel from Belgium to NL
etc
Travel from BE to EN
Travel from BE to FR
Travel from BE to DE
etc
Travel from BE to England
Travel from BE to France
etc

Can anyone help me with that ? I tried several tricks with concatenation, but I don't get anywhere ...

Thanks a lot in advance!

Book1.xlsx

This is an application that run much faster with code. Permutations is hard work.

Please Login or Register  to view this content.

This little snippet just runs through each cell and smooshes it with another cell as long as they aren't on the same row.

To use this, simply go to Excel and hit Alt+F11, go to Insert->Module and paste the code there. Hit the play button or F5 to initiate.