Matrix stiffness-Daigonal

[SPRstructur]

Dear all
Could you sold for me as attachment file below?

Thank u

[Werner_E]

You could use the "stack" function for your first problem and for the second you could write a custom function to create a matrix to your specifications.

BTW, its always better to additionally attach the worksheet itself additionally and not just post pictures.

[SPRstructur]

Thank u  Werner_E

please find attachment file

[Werner_E · Accepted solution]

The attached file should help (Prime 6 format)