Htykuut

Using Google Sheets I have almost finished a macro to create heatsheets for swim meets, but I am having trouble getting rid of the duplicate names. The data only repeats in Column A, but I want to delete the entire row when Column A does have a repeat. So in the example below I need to delete Row 3, Row 7, and Row 8.

Name         IM

James Smith  47.7

James Smith  48.27

Sally Baker  53.76

Katie Jones  57.63

Advay Shah   58.15

Sally Baker  58.65

Katie Jones  59.52

I am using the following lines of code (the spacing is wrong because I struggled with pasting into the post), but it's not doing anything when I run the macro. Obviously I have something incorrect.

  function removeDuplicates() {

  var sheet = SpreadsheetApp.getActiveSheet();

  var data = sheet.getDataRange().getValues();

  var newData = ;

  for (i in data) {

  var row = data[i];

  var duplicate = false;

  for (j in newData) {

  if (row.join() == newData[j].join()) {

    duplicate = true;

  }

}

if (!duplicate) {

  newData.push(row);

}

}

sheet.clearContents();

sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData);

}