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

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

Answer 1

[dpb]

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'
>> 

[Blue]

Neat. thanks.