I try put three cells in one cell automatically

Iron Contributor

I try put three cells in one cell automatically.  I have sample one done on a file How get rest done without type it or copy and paste.

 

 

 

Thanks You 

3 Replies
the simpliest is just =CONCAT(A3:C3) and then copy down
but you could also use CONCATENATE or TEXTJOIN

@sf49ers19238597 You can use simply CONCAT() function like-

=CONCAT(A2:C2)

To make it dynamic spill array, you may use BYROW() function with CONCAT().

=BYROW(A2:INDEX(C:C,COUNTA(A:A)),LAMBDA(rw,CONCAT(rw)))

 

Harun24HR_0-1711335534688.png

 

1. Delete column D
2. Go to D3 and press Ctrl+E
3. Enjoy