How to combine two matrices to one and sort the rows?

Hello, my question is given a matrix M, say 10*5 size and one 10*1 say n. I want to make a new matrix that combine those into one matrix say M_new(10*6 size), the first five columns come from M, and 6th column comes from n.

Afterwards, sort the rows from largest to smallest by the last entry, say the number in n. Is there a good code on this? Thanks.

Answer 1

[Oleg Komarov]

M_new = [M, n];
M_new = sortrows(M_new,6);

See sortrows() for details.

[C Zeng]

Thanks a lot, Oleg!

Is there a way to sort it from largest to smallest? It assumes from smallest to largest.

[Oleg Komarov]

You can either 1) flip M_new upside-down with flipud() after you sorted or 2) sort() in 'descend' order the n, retrieve the index (second output) and apply it to M, then concatenate the sorted n and the sorted M.

[C Zeng]

Thanks, or M_new = sortrows(M_new,-6), right? :-)

[Oleg Komarov]

Yes, I always forget about the minus!!

[C Zeng]

Haha, I just found it.