Sort table with a specific order

Hello everyone!

I have a table with two columns, the first is called ScanID , which contains the id's of some patients, and the second is called Site, which contains the site where the patients belong, going from 1 to 8. What I want is to order the rows of that table based on that Site column values, with the following order: 3,4,5,6,7,1,8.

How can I achieve this?

Thank you so much!

Answer 1

[Walter Roberson]

[found, idx] = ismember(T.Site, [3,4,5,6,7,1,8]);
if any(~found)
   error('Site not on approved list, first at row %d', find(~found,1));
end
[~, sortorder] = sort(idx);
newT = T(sortorder,:);

[Iugo]

Thank you so much @Walter Roberson!! Nailed it!