I'm trying to make three rows in a column join together to make one.
For instance, I want to take cells A5, A6, & A7, combine them into one and put it in A8 separated by a space.
I want to copy that through column Y
Some rows don't have any information in them.
I tried using
=mconcat(A5:A7," ")
and I got this as a result
#NAME?
Any advice?
For instance, I want to take cells A5, A6, & A7, combine them into one and put it in A8 separated by a space.
I want to copy that through column Y
Some rows don't have any information in them.
I tried using
=mconcat(A5:A7," ")
and I got this as a result
#NAME?
Any advice?