https://www.pbainbridge.co.uk/2022/07/move-column-positions.html

Move Column Positions.gs

/** * @OnlyCurrentDoc */

function moveColumns() {

  // get sheet
  var sheet = SpreadsheetApp.getActiveSheet();

  // select columns to be moved ('collegename' & 'shoesize')
  var columnsToMove = sheet.getRange("E1:F1");

  // move columns to the left of 'postcode'
  sheet.moveColumns(columnsToMove, 4);

}


/*
This Function creates a menu item to run this script.
*/

function onOpen() {

  SpreadsheetApp.getUi()
    .createMenu('Admin')
    .addItem('Move Columns', 'moveColumns') // label for menu item, name of function to run.
    .addToUi();

}