I am trying to make an arrayformula in column B, which will copy whatever is in column A into C

at the moment I can use this formula on individual cells in column B: ={"",A1}

However when I try to put this into an arrayformula: =arrayformula({"",A1:A10}) it just returns an error:

Function ARRAY_ROW parameter 2 has mismatched row size. Expected: 1. Actual: 9.

Is there any way to do this?

CodePudding user response：

This is one way to do it. Note that you need to have FALSE or 0 for the 4th split parameter (as illustrated) for this to work.

=ARRAYFORMULA(SPLIT("|"&A1:A10,"|",0,0))

CodePudding user response：

Try

=arrayformula(if(A1:A="",,A1:A))