Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

151
Views
Sorting columns left to right in Google Sheets by alphabet

i have a spreadsheet in google sheets and i need sort columns left to right

enter image description here

enter image description here

about 4 years ago · Juan Pablo Isaza
1 answers
Answer question

0

It can be done manually (select, transponse, sort, transpose back), but if you want a script by some reason, here you go:

function myFunction() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  
  // credits: stackoverflow.com/a/36164530/14265469
  const transpose = m => m[0].map((x,i) => m.map(x => x[i]))

  var [col1, col2, ...etc] = transpose(data);
  var table = transpose([col1, col2, ...etc.sort()]);

  sheet.clearContents().getRange(1,1,table.length,table[0].length).setValues(table)
}

Before:

enter image description here

After:

enter image description here

about 4 years ago · Juan Pablo Isaza Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!