Create lists of all possible pair combinations (excluding repeats) from cells in every row

I have a spreadsheet with around 50,000 rows. Each row contains a list of values across multiple columns that are associated with each other (like attendees at a party).

I'd like to turn each row into a new list that combines the cells in that row into every possible paired combination, like this:

combinaitons-example.PNG

In effect, the result is showing how every cell in each row can be combined in pairs without repeats (i.e. 1,2 can represent 2,1 without needing to actually list 2,1).

• The number of values in each row differs, ranging from 3 to 10
• As shown in the screenshot and attached example spreadsheet, I'd like the solution to stack each list, preferably in a new spreadsheet to maximize the number of available rows before hitting memory limits

Many thanks for any help you can provide!

Thanks, sintek. That works perfectly, although when I run it on many thousands of rows it gives a subscript out of a range error, highlighting 'x = x + 1: Temp(x, 1) = Arr(ii):'. But maybe this is due to blank cells or something? Either way, the code you supplied I can certainly work with so I'll mark as solved and add reputation. Thanks.