[Solved] How to concatenate values from one column with each vales from second column? [closed]

by


In C2 enter:

=INDEX($A$2:$A$99,ROUNDUP(ROWS($1:1)/3,0)) & "_" & INDEX($B$2:$B$33,MOD(ROWS($1:1)-1,3)+1)

and copy downward:

enter image description here

NOTE:

The number 3 in the formula above is there because there are 3 items in column B

To “generalize” the formula replace:

3

with:

(COUNTA($B$2:$B$99))

solved How to concatenate values from one column with each vales from second column? [closed]