Hey folks I am quite new to the software. I have a question of converting a nested matrix as in the attachment to a clean matrix. What I am doing is to manually match the row number to the final clean matrix. But since I will change the number of rows and the number of submatrix rows, is there anyway we can do it smarter? Thanks!
Please post your worksheet, not just pictures.
What is a clean matrix for you, what do you expect as result? A 707 x 4 matrix?
I am debating if I want to collapse this nested matrix to a clean 707*4 matrix or keep it this way. Later I have some complicated calculations involving this nested matrix and another clean 7*4 matrix. I also need to deal with redefinition of the elements in the nested matrix, and thus I thought converting it to a clean 707*4 matrix would be better except operations with several clean 7*4 matrix later. I am kinda stuck at this point, and tried several loops but failed.
This is one way to do the job:
Thank you so much!
I am trying different ways to see which works better!