Formula to combine All elements in 1 Row

hey guys,

I have a problem with combining different cells from 1 row. There's no need to create ALL possible combinations per row (reversed like: keyword1a & keyword1b + keyword1b & keyword1a) --> Just 1 of the 2 combinations is enough.

Is there a proper way to do this with a formula?

Basically this is what I need.



Input
keyword 1a keyword 1b keyword 1c keyword 1d
keyword 2a keyword 2b keyword 2c keyword 2d


Output
keyword 1a keyword 1b
keyword 1a keyword 1c
keyword 1a keyword 1d
keyword 1b keyword 1c
keyword 1b keyword 1d
keyword 1c keyword 1d
keyword 2a keyword 2b
keyword 2a keyword 2c
keyword 2a keyword 2d
keyword 2b keyword 2c
keyword 2b keyword 2d
keyword 2c keyword 2d

Thanks a lot!

It's a bit of an ugly approach, but if your input is X rows with 4 keywords, then I think you can do the following:

With your input in E2:H3, enter the following in A2 and fill down:

=IFERROR(INDEX($E$2:$H$3,CEILING(ROW(1:1)/6,1),MAX(ROUNDDOWN((MOD((ROW(1:1)-1),6)+1)/2,1),1)),"")

Then enter the following in B2 and fill down:

=IFERROR(INDEX($E$2:$H$3,CEILING(ROW(1:1)/6,1),IF((MOD((ROW(1:1)-1),6)+1)>3,CEILING((MOD((ROW(1:1)-1),6)+1)/2,1)+1,(MOD((ROW(1:1)-1),6)+1)+1)),"")

The resulting pairs in columns A and B should match what you're looking for. If you have more than two rows of input keywords, just put them in E4:H? and change the first part of each formula to $E$2:$H$4 or whatever is necessary to incorporate the new input rows. If an input row requires more or less than 4 keywords... then this formula won't work. It's pure pattern creation, there's no actual permutation work being done. Hopefully that's good enough? Take a look at the attachment to see how it looks.