MATLAB: How to take a rectangular matrix of numbers and turn it into a matrix of the form (row, column, number)

columnindexingmatrixrelabellingrow

I want to take a matrix of around 300 rows and 300 columns and put it into the form (row, column, number)

Any help would be appreciated a lot.

Thanks 🙂

If m is your matrix:

m=rand(3,2);
[1+mod(0:numel(m)-1,size(m,1))' 1+fix((0:numel(m)-1)/size(m,1))' m(:)]

If ‘M’ os your matrix, this works:

M = M(M(:,3)==1, :)

Use can use rem() to filter the rows where the third column is multiple of 100 and then use logical indexing

M; % nx3 matrix
idx = rem(M(:,3),100)==0;
M_new = M(idx, :);