How do i delete a repeating row

Hello guys

I am trying to delete rows that has the same string value in collumn 1, but when I run the script nothing changes. Does anybody know what is wrong?

Answer 1

[Cris LaPierre]

Modified from this example

[C,ia] = unique(grades{:, 1});
B = grades(ia,:)

See this page for alternate ways to access data in a table.

Answer 2

[Image Analyst]

Try this. Adapt as needed

m = [1,2,3;4,5,6;4,5,6;7,8,9]

m = 4×3

1 2 3 4 5 6 4 5 6 7 8 9

diffRows = diff(m, 1)

diffRows = 3×3

3 3 3 0 0 0 3 3 3

% Delete second row if it's a duplicate and adjacent.
rowsToDelete = find(all(diffRows == 0, 2)) + 1

rowsToDelete = 3

m(rowsToDelete, :) = []

m = 3×3

1 2 3 4 5 6 7 8 9

% Alternatively delete first row if it's a duplicate and adjacent.
% rowsToDelete = find(all(diffRows == 0, 2))
% m(rowsToDelete, :) = []