Compare Column A to Column E and data should rearrange based on matched data in either columns [closed]

I’m trying to get some answers on how to automatically sort/match/filter columns and rearrange data if they match.

For example:
screenshot here

So when the name in column A matches with Column E, column E will them move to the adjacent cell of the match and so on. So for those that does not have a match, whether in Column A and B, they’ll be thrown below or above.

I tried using a script that was answered by Tanaike but the application might not be the same based on the conditions.

Any help would be appreciated big time!
Thanks in advance!

Dexter

I think this is what you want but I can’t be sure:

function sortof() {
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getSheetByName("Sheet0");
  const vs = sh.getRange(2, 1, sh.getLastRow() - 1, sh.getLastColumn()).getDisplayValues();
  vs.sort((a, b) => {
    if (a[0] > b[0]) return 1;
    if (b[0] > a[0]) return -1;
    if (a[0] == b[0]) return 0;
  })
  sh.getRange(2, 1, vs.length, vs[0].length).setValues(vs)
  let ob = vs.reduce((a, r, i, A) => {
    let idx = a["col1"].indexOf(r[4]);
    if (~idx) {
      let t = A[idx][4]
      a["col5"][idx] = [r[4]];
      a["col5"][i] = [t];
    } else {
      if (!a["col5"][i]) {
        a["col5"][i] = [r[4]];
      }
    }
    return a;
  }, { col1: vs.map(r => r[0]), col5: [] })
  sh.getRange(2, 5, ob["col5"].length).setValues(ob["col5"]);
  Logger.log(JSON.stringify(ob));
}

Sheet0: before

Sheet0: after