How to rearrange a column by a specific order?

Lets say i have a table:

IDname | IDnumber | version | status

x1 | 1 | v1 | backlog

x2 | 1 | v1 | Done

x3 | 1 | v1 | verify

x4 | 1 | v1 | Done

x5 | 1 | v1 | backlog

x6 | 1 | v1 | verify

x7 | 1 | v1 | verify

I want to be able to group and reorder column "Status" like this:

IDname | IDnumber | version | status

x1 | 1 | v1 | backlog

x5 | 1 | v1 | backlog

x3 | 1 | v1 | verify

x6 | 1 | v1 | verify

x7 | 1 | v1 | verify

x2 | 1 | v1 | Done

x4 | 1 | v1 | Done

I thought you would categorical the column and try sort it using some like this

datanew = categorical(data.Status, {'backlog', 'verify', 'done'} 

but this doesnt seem to work..

Cheers!

Answer 1

[KSSV]

How about using sort?

s = [{'Done'    }
{'verify'  }
{'Done'    }
{'backlog' }
{'verify'  }
{'verify'  }] ;
s = sort(s)

You can access that column using T.status, where T is your table and status is your column.

[MKM]

doesnt this only sort the data by alphabetical roder? I am looking for a specific pattern, not alphabetical.

[KSSV]

Refer this: https://in.mathworks.com/matlabcentral/answers/43816-how-can-i-sort-a-string-both-alphabetically-and-numerically