function m1() {
var spreadsheet = SpreadsheetApp.getActive();
var currentCell = spreadsheet.getCurrentCell();
spreadsheet.getActiveRange().getDataRegion().activate();
currentCell.activateAsCurrentCell();
spreadsheet.getActiveRange().copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
};

function test2() {
let ss = SpreadsheetApp.getActiveSpreadsheet();
let sheet = ss.getSheetByName("Лист1");

let findingRange = sheet.getRange("A:A").getValues()
let valToFind = 1;

let row;
for(let i = 0; i<findingRange.length;i++){
if(findingRange[i].indexOf(valToFind)!== -1){
row = i+1;
//let znach = sheet.getRange(row,2).getValue();
sheet.getRange(row,2).setValue(sheet.getRange(row,2).getValue());
continue;
}
}
}

function test3() {
  let ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheet = ss.getSheetByName("Лист1");

  let stolbec_dat = sheet.getRange("A:A").getValues()
  let stroca_zagolovkov = sheet.getRange("1:1").getValues()
  let poizk_daty = 1;
  let poisk_prodazh = 2;

  let nyzhnaya_stroka;
  let nyzhny_stolbec;
  for(let s = 0; s<stroca_zagolovkov.length;s++){
    if(stroca_zagolovkov[s].indexOf(poisk_prodazh)!== -1){
      nyzhny_stolbec = s+1;

      for(let i = 0; i<stolbec_dat.length;i++){
        if(stolbec_dat[i].indexOf(poizk_daty)!== -1){
          nyzhnaya_stroka = i+1;
          sheet.getRange(nyzhnaya_stroka,nyzhny_stolbec).setValue(sheet.getRange(nyzhnaya_stroka,nyzhny_stolbec).getValue());
        continue;
      }
    }
      continue;
    }
  }
    console.log(stroca_zagolovkov);
}

function test3m() {
var ss = SpreadsheetApp.getActive();
var sheet = ss.getSheetByName("Лист1");
var range = sheet.getDataRange();
var values = range.getValues();
for (var i = 1; i < values.length; i++) {
    if (values[i][0] == 1) {
        for (var j = 1; j < values[0].length; j++) {
            if (values[0][j] == 2) {
                range.getCell(i + 1, j + 1).setValue(values[i][j]);
            }
        }
    }
}