Forum Discussion
Excel multiple columns to rows
Dear, I would kindly ask for help. I'm using Excel 2013. I have 16 columns and big numbers of rows (e.g. 300+) I would like that each row, would be placed next to the ending (16th) column. ...
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.