Sort first dimension of two dimensional array only Google Script

Question

I am trying to sort only the first dimension of a two-dimensional array

I have

arr = [a,b,c,a,b,c,a,b,c]

arr1 = arr.sort() --> arr1 = [a,a,a,b,b,b,c,c,c]

result = transpose([arr1,arr])

Which gives

result = [[[a],[a]],[[a],[a]],[[a],[a]],[[b],[b]],[[b],[b]],[[b],[b]],[[c],[c]],[[c],[c]],[[c],[c]]]

But I need (and expected)

result = [[[a],[a]],[[a],[b]],[[a],[c]],[[b],[a]],[[b],[b]],[[b],[c]],[[c],[a]],[[c],[b]],[[c],[c]]]

Thanks

From this, you'll see that when you sort arr, both arr and arr1 get sorted. — ADW
– ADW, Commented Jul 8, 2019 at 15:57

J. G. · Accepted Answer · 2019-07-08 16:06:58Z

2

You need to make an actual clone of the array, arr is being sorted in what you are doing.

try this:

arr = [a,b,c,a,b,c,a,b,c]

arr1 = arr.slice(0);
arr1.sort();

result = transpose([arr1,arr])

My testing is limited because transpose isn't a GAS function and you didn't include it.

Actually with, this, it seems to work:

function transpose(a)
{
  return Object.keys(a[0]).map(function (c) { return a.map(function (r) { return r[c]; }); });
}

answered Jul 8, 2019 at 16:06

J. G.

1,8302 gold badges16 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1