Find duplicate rows in the spreadsheet with the eq function and delete them. https://cafe.naver.com/eojji/365

Delete duplicate rows.js

function myFunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var value;
  var i = 0;
  var thisRow = 2;
  do {
    value = sheet.getRange(thisRow, 1).getValue();
    if (value) {
      thisRow++;
    } else {
      sheet.deleteRow(thisRow);
    }
    i++;
  } while (thisRow <= sheet.getLastRow() &&  i < 1000);
  Logger.log('Row: %s', thisRow);
}