Building Matrix of range of Numbers

[Abdmujib]

The Picture attached is a matrix of 10 X 10 (10 columns and 10 rows). I did it manually then and it was tedious. there is now a need to do at least 300 x 300. Pls is there a way to get it done easily without doing it manually.

Thanks

 

[StephenCrump]

Duplicated, and responded to here: How can I create a matrix of 300 x 300 automatically in excel

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.