is it there is a way, preferably with formula/s, to perform element-wise multiplication of two arrays of numbers?
For example, if I have two fields with arrays [1, 2, 3] and [4, 5, 6] respectively, can I write a formula that produces [4, 10, 18]?
_
I would also need a formula for:
Column1 (array 1): 2, 3, 5
Column2 (array 2): 5, 4, 1
Expected output: 7, 7, 6
is this achievable?