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.


[TABLE="width: 720"]
<tbody>[TR]
[TD]keyword 1a[/TD]
[TD]keyword 1b[/TD]
[TD]keyword 1c[/TD]
[TD]keyword 1d[/TD]
[TD][/TD]
[TD]INPUT[/TD]
[/TR]
[TR]
[TD]keyword 2a[/TD]
[TD]keyword 2b[/TD]
[TD]keyword 2c[/TD]
[TD]keyword 2d[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]and so on....
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]keyword 1a[/TD]
[TD]keyword 1b[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]OUTPUT[/TD]
[/TR]
[TR]
[TD]keyword 1a[/TD]
[TD]keyword 1c[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 1a[/TD]
[TD]keyword 1d[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 1b[/TD]
[TD]keyword 1c[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 1b[/TD]
[TD]keyword 1d[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]keyword 1c[/TD]
[TD]keyword 1d[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]keyword 2a[/TD]
[TD]keyword 2b[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 2a[/TD]
[TD]keyword 2c[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 2a[/TD]
[TD]keyword 2d[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 2b[/TD]
[TD]keyword 2c[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 2b[/TD]
[TD]keyword 2d[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]keyword 2c
and so on...[/TD]
[TD]keyword 2d[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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!