MATLAB: How to obtain the unique combinations of two columns in a table

MATLAB

Hi,
I am trying to obtain all the unique combinations of two columns in a table. Lets say we have the following table:
year = {1994, 1994, 1994, 1995, 1995, 1995, 1996, 1996, 1996}.';
type = {'AA', 'BB', 'CC', 'BB', 'BB', 'BB', 'AA', 'CC', 'CC'}.';
t = table(year, type);
How can I extract the unique combinations of 'year' and 'type' in order to get something like this:
year = {1994, 1994, 1994, 1995, 1996, 1996}.';
type = {'AA', 'BB', 'CC', 'BB', 'AA', 'CC'}.';
answer = table(year, type);
Thank you

Best Answer

year = [1994, 1994, 1994, 1995, 1995, 1995, 1996, 1996, 1996].';
type = {'AA', 'BB', 'CC', 'BB', 'BB', 'BB', 'AA', 'CC', 'CC'}.';
t = table(year, type);
>> unique(t,'rows')
ans =
  6×2 table
    year    type
    ____    ____
    1994    'AA'
    1994    'BB'
    1994    'CC'
    1995    'BB'
    1996    'AA'
    1996    'CC'
>>
Related Question