Google sheets keyword combination formula?

Hi all

Is there a formula for google sheets that will combine 2 keywords from a list together?

For example

In my attached sheet example I'd like to have different combinations

For example

LifeApe
ApeLife
ApeServices
ShopCare

You want to see them as a list in another column?

Pete

Originally Posted by Pete_UK

You want to see them as a list in another column?

Pete

Yes please

Is there a formula to do this?

Originally Posted by Pete_UK

You want to see them as a list in another column?

Pete

Do you know the formula ?

An easy way is to insert a new row at the top of the sheet, and then to copy/transpose the list from A2:down into B1:across, and then you can just combine the left-most value with the top-most value, unless they are the same. This will give you a 2-D grid of all combinations. You could use this formula in B2 for that:

=IF($A2="","",IF($A2=B$1,"",$A2&" "&B$1))

and then copy across and down as required.

Hope this helps.

Pete

Originally Posted by Pete_UK

An easy way is to insert a new row at the top of the sheet, and then to copy/transpose the list from A2:down into B1:across, and then you can just combine the left-most value with the top-most value, unless they are the same. This will give you a 2-D grid of all combinations. You could use this formula in B2 for that:

=IF($A2="","",IF($A2=B$1,"",$A2&" "&B$1))

and then copy across and down as required.

Hope this helps.

Pete

thanks pete but when i paste this code into column B it just shows the same info as whats in column A should it be doing that?

See attached file.

Hope this helps.

Pete