Nested loop to concatenate 2 columns of data

**JohnnyBGood** · 10-27-2009, 03:07 PM

Hi,

I think I just need a basic Nested For Loop code...

I have a list of in column A, from A1:A537

and another list in column B, for B1:B50

I want to add a column that concatenates,

each item in Column A to B1 (so 537 rows), then again each item in Column A to B2, another 537 rows, etc.. this loop is repeated 50 times, one for each name in column B.

**Leith Ross** · 10-27-2009, 05:00 PM

Hello JohnnyBGood,

Here is a macro you can use. It uses column "C" as the helper column.

Please Login or Register  to view this content.

**mikerickson** · 10-27-2009, 05:18 PM

There is no need for a loop

Please Login or Register  to view this content.

**JohnnyBGood** · 10-27-2009, 09:11 PM

Thanks very much guys...

Leith, I was close to yours, except that N=N+1 part....

I couldn't figure out how to go past row 537 to keep adding fields.

**pvr1983** · 07-15-2015, 07:42 AM

dear friends i was searching for concatenating column with row data
i found this thread i have a different proposition
i have values in coloumn a and row 2 (these are all in sheet1)
i need these values to be concatenated in the following manner in sheet 2
sheet2A2=sheet1(a2,b2)
sheet2A3=sheet1(a2,c2)
sheet2A4=sheet1(a2,d2)
sheet2A5=sheet1(a2,e2)

until it finds the empty cell in row 2
then it has to loop for A3 then A4 etc

regards
pvr