Hi,
I am trying to pull out values from columns 3 and 4 based on what is in column 2. The numbers I am interested in are the values WITH a '1' from column 2. Then I wish to put these values into a ?x1 matrix. I put the '?' there because the length of the matrix can vary with different file inputs, but the width will stay as 1.
This is what the output should look like.
Here is my attempt at coding this problem:
*Photo Removed***
This code partially works, but when it loops, the previous results get over written.
Where 'e' is the length of Matrix_One which in this example is 7. Where Matrix_One is the 7×4 matrix and Matrix_Two SHOULD be the 10×1 matrix.
How should I go about fixing my code?
Thanks! I look forward to reading some answers.
Best Answer
Where M is your matrix:
or