Formula for combining all elements in 1 Row

david_cc

New Member
Joined
Jan 20, 2017
Messages
12
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 1akeyword 1bkeyword 1ckeyword 1dINPUT
keyword 2akeyword 2bkeyword 2ckeyword 2d
and so on....
keyword 1akeyword 1b


OUTPUT
keyword 1akeyword 1c



keyword 1akeyword 1d



keyword 1bkeyword 1c



keyword 1bkeyword 1d
keyword 1ckeyword 1d
keyword 2akeyword 2b



keyword 2akeyword 2c



keyword 2akeyword 2d



keyword 2bkeyword 2c



keyword 2bkeyword 2d



keyword 2c
and so on...
keyword 2d

<tbody>
</tbody>


Thanks for your help!
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

david_cc

New Member
Joined
Jan 20, 2017
Messages
12
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

MrExcel MVP
Joined
May 7, 2008
Messages
21,779
Office Version
  1. 2010
Platform
  1. Windows
You're welcome to modify the code.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,509
Messages
5,596,558
Members
414,077
Latest member
ammylar5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top