cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

converting nested matrix to a "clean" matrix

yhuang-8
6-Contributor

converting nested matrix to a "clean" matrix

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!

4 REPLIES 4
Werner_E
25-Diamond I
(To:yhuang-8)

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?

yhuang-8
6-Contributor
(To:Werner_E)

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. 

Werner_E
25-Diamond I
(To:yhuang-8)

This is one way to do the job:

B.png

yhuang-8
6-Contributor
(To:Werner_E)

Thank you so much!

I am trying different ways to see which works better!

Announcements

Top Tags