Skip to main content
Y
yhuang-81-Visitor
1-Visitor
May 17, 2018
Question

converting nested matrix to a "clean" matrix

  • May 17, 2018
  • 1 reply
  • 2655 views

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!

1 reply

W
Werner_E25-Diamond I
25-Diamond I
May 17, 2018

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?

Y
yhuang-81-VisitorAuthor
1-Visitor
May 17, 2018

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. 

W
Werner_E25-Diamond I
25-Diamond I
May 17, 2018

This is one way to do the job:

B.png

    Terms & ConditionsAccessibility statement