Forum Discussion
Merging text column
Hi all, I want to merge 2 column A and B and have result in column C (follow picture). In this case I use CONCATENATE($A$1," ",B2) and CONCATENATE($A$2," ",B2) but it's slowly. Can I use only on...
lacala11 , that could be as
=OFFSET($A$1,INT((ROW()-1)/ROWS($B$1:$B$5)),0)&" "& OFFSET($B$1,MOD(ROW()-1,ROWS($B$1:$B$5)),0)
and drag it down. Is to be adjusted to your actual ranges and/or you may use dynamic ranges.