sort the matrix X, then sort the another matrix in the same order as X

I have a matrix X which of size 100 by 100, I had sorted the rows of matrix X in the descending order so that the maximum in each row stays in the first column and store it in a new matrix Y.

X = rand(100,100);
[Y, indx] = sort(X,2,'descend');
P = rand(100,100);

I need to use the same sorting order used while sorting X in matrix P and store it in matrix Q. I had tried using the code,

Q = P(indx);

This makes the sorting indices in the columns instead of rows. I need the sorting to be implemented in respective rows of P.

Thanks in advance!

Answer 1

[dpb]

Matrix expansion of subscripts gets you here...

Q=cell2mat(arrayfun(@(i) P(i,indx(i,:)),[1:size(P,1)].','UniformOutput',false));

[Phoenix]

Thank you for the answer. This is what I need.