Originally coming from Excel I know the temptation of putting variables in columns, but I cannot remember now any case where improving the data model didn’t solve my need for getting the column with a formula.
Why don’t you just use a data-model like in this example with a data point per row ? With grouping you can simulate the original layout if that’s more convenient for visualization or data input.