Forum Discussion
Creating a Diagonal Matrix for a vector data
Good day to everyone. I am trying to create a diagonal matrix of dimension (900x900) from a vector data of n=900. Can someone guide me through how best I can generate the matrix? Thanks
ok, Thanks.Savia
I have a single column that has 900 cells contained with data. I want to split these 900-cell vector data into a diagonal matrix with each data on the column spread across the diagonal of the matrix formed. e.g. say a1=2, a2=3 and a3=5....I want a diagonal matrix that will have a1=2, b2=3,c3=5 etc. with other cells of the matrix having "0" values.
ogungbile Thanks, that helped a lot.
I attach a file with both a traditional formula approach and one based on the newer dynamic array functions (Office 365 only).