Concatenate two rows with condition

[Deepak Sharma]

Hi All,

Is it possible to display two columns's (A and B Column's) result in C column like :-

Col A Col B
1 A
2 B
3 C
4 D

Col C (Result should as below)
1A
1B
1C
1D
2A
2B
2C
2D
3A
3B
3C
3D
4A
4B
4C
4D

Regards,

 

[bosco_yip]

In C2, copied down :

=IFERROR(INDEX(A$2:A$5,INT((ROWS($1:1)-1)/4)+1)&INDEX(B$2:B$5,MOD(ROWS($1:1)-1,4)+1),"")

Regards
Bosco

 

[Deepak Sharma]

Thanks Bosco! It's working perfectly! Thank you so much !


Regards,