Finds End of List an Populates

**Camel** · 07-20-2012, 08:05 AM

Hi

I have a spreadsheet and need some help with a formula.

I have 2 columns. A & B.

Col A contains some keywords. Col B contains some search terms.

I want to concatenate every value in col A with every value in Col b AND most importantly display them in one col. i.e. Results col 3.

So after first iteration of A1 with all B, it finds end of data in Results column and then begins second iteration (A2 with all of B) and it continues until all are done.

See attached sample4.

Alex

**martindwilson** · 07-20-2012, 08:54 AM

in c2

Formula:

Please Login or Register  to view this content.

**Camel** · 07-20-2012, 08:58 AM

You rock....that is exactly what I have been looking for! Can I give you a double thanks you?

**ChemistB** · 07-20-2012, 08:59 AM

Try this. Adjust the references to row 40 to whatever you think your maximum row will be in A and B

Formula:

Please Login or Register  to view this content.

Does that work for you?

**ChemistB** · 07-20-2012, 08:59 AM

Dang, out-typed by that swift fingered Martin again.

**Camel** · 07-20-2012, 09:00 AM

Perfect! Two great answers!

**Camel** · 07-23-2012, 10:39 AM

Hi

I have been reviewing the answer provided and it works, but I need to tweak it slightly.

This time, in column B I will have a text placeholder. E.g. TEXT.

The formula needs to take every row in col A, and insert/replace the text in the placeholder.

E.g. "inurl: TEXT" submission
OR
TEXT "submission"
OR
"submission of TEXT"
OR
"submissions of" TEXT

This would then be replaced with every row in Col A. E.g. "inurl: learners permits" submissions or "inurl: k53 tests"

Many Thanks!