Google-sheets – Function to search columns and tally data

In new Google Sheets there is no need for a function. Just select B and C, Ctrl+c, select the cell immediately to the right of Aand Edit, Paste special, Paste transpose.

This creates copies of B and C but there is no linkage so those below A may be deleted without affect those to the right of A.

This little script will:

• create an extra menu item, thus making it accessible throughout the workbook. T
• the menu item will set the active range to column E, last row + 1.

See the example I've prepared: Creating a function...Google spreadsheet is opened (edit rights)

function onOpen() {
  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // create menu
  var menu = [{name: "get last row", functionName: "getLastRow"}];

  // add to menu
  ss.addMenu("Rows", menu);  

  // execute function
  getLastRow();  
}

function getLastRow() {
  // get active spreadsheet
  var ss = SpreadsheetApp.getActive();

  // get active sheet
  var sh = ss.getActiveSheet();

  // get column F
  var indLastCol = sh.getLastColumn()-1;

  // get last row + 1
  var indRowWithout = sh.getLastRow()+1;

  // set new active range
  sh.setActiveCell('E'+indRowWithout);
}