I have an excel sheet with some column data that I would like to use for some matrix multiplications using MMULT-function. For that purpose I need to reshape the column data first. I would like to do the reshaping using a dynamic array function since that could then feed directly into the MMULT function without having to actually display the reshaped matrix in the sheet (i.e. keeping only the column with the input data visible for the user). I am aware of ideas such as the one outlined here

CodePudding user response：

For reshaping a 9x1 array into a 3x3 array:

INDEX(B3:B11,SEQUENCE(ROWS(B3:B11)/3,3))