Mar 24 2024 04:35 PM
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
Mar 24 2024 06:46 PM
Mar 24 2024 08:01 PM
@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)))
Mar 25 2024 01:56 AM