Find unique rows in a cell array with mixed data types

Hi,

I have a cell array formatted like the following:

    >> stations
    'WOSB'    [    NaN]   [     NaN]
    'YOUB'    [48.8266]   [-121.123]
    ..

It contains a lot of "stations" denoted by a several character string (e.g. 'WOSB'), followed by a latitude and a longitude. A lot of the entries have NaN in the lat/long places as displayed above, and there are a ton of repeats. I want to extract the unique rows of this cell array, but when I try I get the following:

     unique(stations)

     Error using *cell/unique* (line xx)

     Input A must be a cell array of strings.

How can I get the unique rows from this cell array with the mixed types?

Thanks,

Answer 1

[dpb]

>> t=cell2table(stations)
t =
2×3 table
  stations1    stations2    stations3
  _________    _________    _________
  'WOSB'           NaN           NaN 
  'YOUB'       48.8266      -121.123 
>> unique(t,'rows')
ans =
2×3 table
  stations1    stations2    stations3
  _________    _________    _________
  'WOSB'           NaN           NaN 
  'YOUB'       48.8266      -121.123 
>>

[ZigzS]

Thank you!