Calculating Popular Combinations

Hi guys,

I am new to the forum and looking for some help calculating popular routes of itineraries.

I want to determine which routes in a travel itinerary are most commonly put together.

There are multiple ItineraryID and each one will have multiple Locations. For example, the below data would display the table below it.

Itinerary Code / Location
101 /Thailand
101 /Cambodia
101 /Vietnam
102 /Vietnam
103 /Tanzania
103 /Cambodia
104 /Cambodia
104 /Thailand
104 /Vietnam
105 /Thailand
105 /Vietnam
106 /Vietnam


To display:

Combination Count

Vietnam / 2
Tanzania + Cambodia / 1
Cambodia+Thailand+Vietnam / 1
Thailand + Cambodia + Vietnam / 1
Thailand+Vietnam / 1

Total Count should equal Total Itineraries.

Any help would be much appreciated!