Formula for combining all elements in 1 Row

[david_cc]

Hi 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?

Basically this is what I need.

keyword 1a	keyword 1b	keyword 1c	keyword 1d		INPUT
keyword 2a	keyword 2b	keyword 2c	keyword 2d
and so on....
keyword 1a	keyword 1b				OUTPUT
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 and so on...	keyword 2d

<tbody>
</tbody>

Thanks for your help!

 

[shg]

Welcome to the board.

There's a workbook with both VBA- and formula-based methods to do that at https://app.box.com/s/47b28f19d794b25511be

 

[david_cc]

Welcome to the board.

There's a workbook with both VBA- and formula-based methods to do that at https://app.box.com/s/47b28f19d794b25511be

Thanks, I think this goes in right direction but I can't figure out how to change the workbook to create only 2 Output colums (not 4) So basically Input are 4 Columns but Output should only 2. Also the double combinations (reversed) are not needed.

Any help would be appreciated.

 

[shg]

Ah, combinations for each row. See the workbook at https://app.box.com/s/b9b9fc06beb63b9562f9.

You would need to do it one row at a time.

 

[david_cc]

Ah, combinations for each row. See the workbook at https://app.box.com/s/b9b9fc06beb63b9562f9.

You would need to do it one row at a time.

Yes this is very close. Actually it does what it needs to do. Like Output wise...

But my entire list contains over 2000 rows. Is there a way to do this in bulk?

 

[shg]

You're welcome to modify the code.

 

[david_cc]

You're welcome to modify the code.

Yes found out Thanks a lot, problem solved!