Forum Discussion
Excel multiple columns to rows
For me the answer is "Do not use 2013 or, indeed, anything other than 365". The simplicity of the formula
= TOROW(array)shows why.
- Funny most mathematicians or physicists I know love legacy, it is the IT people that prefer the more coding look alike 365….
No, I have maths, theoretical physics and astronomy degrees from way back, but my work was as an aeronautics research engineer. The methods I applied were originally known as matrix methods so I may well have written more matrix formulae than English language sentences!
I loath the concept of relative referencing, an array of scalar formulas is a poor substitute for a proper array formula. I don't like the A1 notation either. In a formula I want to know what the terms represent, not where they happen to be located on a worksheet. Sure, it works well for others who want a hands-on experience and no fancy theory, but it's not for me!
There, that should get me drummed out of the Brownie spreadsheet circle!
- Yes, 365 is more powerful. legacy is mainly to amuse myself. I see A1 as an alternative for (i, j) indexing for two dimension array. so I am reasonably ok with it. It is the 1 based indexing that annoys me. I prefer array index to start from 0.
