How to pull out elements of a matrix based on certain conditions

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 7x4 matrix and Matrix_Two SHOULD be the 10x1 matrix.

How should I go about fixing my code?

Thanks! I look forward to reading some answers.

Answer 1

[Stephen23]

Where M is your matrix:

reshape(M(M(:,2)==1,3:4).',[],1)

or

tmp = M(M(:,2)==1,3:4).'
tmp(:)

[Darrian Low]

You saved me again mate. Thank you so much for your help!

Answer 2

[Walter Roberson]

mask = Matrix_One(:,2) == 1;
Matrix_Two = Matrix_One(mask,3:4);

[Darrian Low]

That's about half way there. The problem is, this is the output:

**Photo Removed**

However I am after this beauty:

**Photo Removed**

Thanks a bunch for your help though. Progress is happening.

[Walter Roberson]

Matrix_Two = reshape(Matrix_One(mask,3:4) .', [], 1);