Data sorting.

Dear all, I have the following database: Company Year Data A 2000 2 A 2001 5 A 2002 4 B 2000 0 B 2001 6 B 2002 5 C 2000 1 C 2001 2 C 2002 7

However, I need to sort as follows: Company Year Data Period A 2000 2 1 B 2000 0 1 C 2000 1 1 A 2001 5 2 B 2001 6 2 C 2001 2 2 A 2002 4 3 B 2002 5 3 C 2002 7 3

Can anyone help me? Thanks a lot. Marcus Vinicius

Answer 1

[Onomitra Ghosh]

Get them all in a cell array without the header and use the sortcell function according to the column you want to sort:

http://www.mathworks.com/matlabcentral/fileexchange/13770-sorting-a-cell-array