Existuje způsob, jak seskupit řádky s určitým jménem(kód) jako seznam lidí, kteří žijí v různých státech a uvedení všech TX dohromady a LA togethe

function sortByState() {
  const sA = ["AL","AK","AS","AZ","AR","CA","CO","CT","DE","DC","FL","GA","GU","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","MP","OH","OK","OR","PA","PR","RI","SC","SD","TN","TX","UT","VT","VA","VI","WA","WV","WI","WY"];
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getActiveSheet();
  const hA = sh.getRange(1, 1, 1, sh.getLastColumn()).getValues()[0];
  let idx = {};
  hA.forEach((h, i) => { idx[h] = i; });
  const rg = sh.getRange(2, 1, sh.getLastRow() - 1, sh.getLastColumn());
  const vs = rg.getValues().sort((a,b) => {
    vA = sA.indexOf(a[idx['State']]);
    vB = sA.indexOf(b[idx['State']]);
    return vA - vB;
  });
  rg.clearContent();
  sh.getRange(2,1,vs.length,vs[0].length).setValues(vs);
}