Google Sheets: How to combine cells into two columns to show all links between the elements in the same row? : I'm working on a Gephi project where I need to define links between people (who worked with who).
 
I have a Google Sheet document with names in each row.
Ex:
John | Mary | Brian | Dave
Emily | David | Sara

I'm looking for a function that could display me then who worked with who in two columns. This way:
John | Mary
John | Brian
John | Dave
Mary | Brian
Mary | Dave
Brian | Dave
Emily | David
Emily | Sara
David | Sara

If you think Google Sheets ain't the thing and it's possible to do it on Excel, you can send me a suggestion too :-)

Thanks in advance (and I hope I made myself clear)