How to combine cells in a simple combination (combinatorics) fashion

[Acomuna]

Hi guys!
I've looked for a way to do this in several foruns and website and found no clue...
Hope someone can help me!

Here is a sample of the data I have:

Student1	Student2	Student3	Student4
Nascimento MS	Espindola CF	do Prado C
Bhansali S	Nascimento MS	Dhawan V	Amarins MB
Bozek T	Blazekovic A
Thewjitcharoen Y	Nascimento MS	do Prado C	Nakasatien S
Jonas MI	Bhansali S	Amarins MB

<tbody>
</tbody>

I want an arrangement of these cells, outputting pairs that reflect how many times a particular student interacted in these groups.
In other words, it is a simple combination. For each group, there are n!/p!*(n-p)! possibilities of interaction, where "n" is the number of the students in each group (in the sample, ranging from 2 to 4) and "p" equals 2 (pairs of interaction).
Thus, the output would be something like this:

Nascimento MS	Espindola CF
Nascimento MS	do Prado C
Espindola CF	do Prado C
Bhansali S	Nascimento MS
Bhansali S	Dhawan V
Bhansali S	Amarins MB
Nascimento MS	Dhawan V
Nascimento MS	Amarins MB
Dhawan V	Amarins MB
Bozek T	Blazekovic A
Thewjitcharoen Y	Nascimento MS
Thewjitcharoen Y	do Prado C
Thewjitcharoen Y	Nakasatien S
Nascimento MS	do Prado C
Nascimento MS	Nakasatien S
do Prado C	Nakasatien S

<tbody>
</tbody>

<table class="wysiwyg_dashes wysiwyg_cms_table_sheet0 wysiwyg_cms_table_gridlines" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody></tbody></table>...and so on...


It is my first post, but I hope I made it clear enough.

 

[mole999]

Would you please add the cross posted hyperlink locations to this thread

 

[Acomuna]

Hi, mole999!
I meant that I searched for it everywhere, but I haven't asked this question anywhere. So it was not cross posted.
Thanks!

 

[mole999]

Thanks for confirming