Concatenate Multiple Rows to Produce Different String Combos?

**boba7523** · 06-29-2015, 12:29 AM

Hi everyone,

I'd like to know if I can use concatenation to combine strings from 3 different rows to produce multiple phrase combinations.

First row will be my "prefix"
Second row will be my "base"
Third row will be my "suffix"

Example:
Prefix:

where to buy	computer	in the world
what is	laptop	on amazon
best	desktop computer	on ebay

Any way to get all the possible combos in this order: prefix - base - suffix?

For example...

Where to buy computer in the world
Where to buy computer on amazon
Where to buy computer on ebay

**NeedForExcel** · 06-29-2015, 12:56 AM

Here!

Try out the file

**boba7523** · 06-29-2015, 01:26 AM

The file contains macro which my Excel Mac can't open

This can't be done with concatenation formula?

**NeedForExcel** · 06-29-2015, 01:31 AM

Not very sure if that can be done using Formulas..

**samba_ravi** · 06-29-2015, 02:44 AM

see the attached file use below formula and copy towards down
=IF(ROW(A1)>COUNTA($A$1:$A$3)*COUNTA($B$1:$B$10)*COUNTA($C$1:$C$10),"",INDEX($A$1:$A$10,INT((ROW(A1)-1)/(COUNTA($B$1:$B$10)*COUNTA($C$1:$C$10)))+1)&" "&INDEX($B$1:$B$10,MOD(INT((ROW(A1)-1)/COUNTA($C$1:$C$10)),COUNTA($B$1:$B$10))+1)&" "&INDEX($C$1:$C$10,MOD(ROW(A1)-1,COUNTA($C$1:$C$10))+1))

Please Login or Register  to view this content.

**NeedForExcel** · 06-29-2015, 02:49 AM

@nflsales

Beautiful Formula..

Concatenate Multiple Rows to Produce Different String Combos?

LinkBack

Thread Tools

Rate This Thread

Display

Concatenate Multiple Rows to Produce Different String Combos?

Re: Concatenate Multiple Rows to Produce Different String Combos?

Re: Concatenate Multiple Rows to Produce Different String Combos?

Re: Concatenate Multiple Rows to Produce Different String Combos?

Re: Concatenate Multiple Rows to Produce Different String Combos?

Re: Concatenate Multiple Rows to Produce Different String Combos?

Thread Information

Users Browsing this Thread

Similar Threads

Concatenate 6 columns, produce all combinations comprised of the 6 variables in order

[SOLVED] concatenate rows of values in a string

[SOLVED] concatenate two columns of numbers does not produce concatenated value

VBA to Delete Duplicate Rows and Concatenate a String

Concatenate cells to produce full postal address

Bookmarks

Bookmarks

Posting Permissions