I have a small problem. I would like to multiply all the numbers in a cell from a new line by 1.8, but unfortunately I am getting gently lost. I tried combining with array and split but in the end I was unsuccessful.
>Solution :
For Google sheets try the following:
=BYROW(B111:B114,
LAMBDA(y,
INDEX(IFERROR(JOIN(CHAR(10),(SPLIT(y,CHAR(10))*2))))))
(Do adjust the formula according to your ranges and locale)

