Google Sheets: Return Multi Dimensional Array (JavaScript)

Question

Let's assume I have four existing arrays:

var one =   ["apple","banana","berry"];
var two =   ["fobar", "barfoo", "farboo"];
var three = [13, 421];
var four =  ["seven", "eight", "eleven"];

How would I merge them into one array and return it in the most simple way? What I got is

var result = [one, two, three, four];

resulting in

|-----------------------------|
|  apple  |  banana  | berry  |  
|  foobar |  barfoo  | farboo |  
|  13     |  421     |        |
|  seven  |  eight   | eleven |
|-----------------------------|

However, what I actually need is this:

|------------------------------------|
|  apple  |  foobar  | 13  |  seven  |
|  banana |  barfoo  | 421 |  eight  |
|  berry  |  farboo  |     |  eleven |
|------------------------------------|

Warning to those answering: Google Apps Script is roughly ES3 (yes, 3) plus some standard library features from ES5. (I hear there's an update in the works, though.) — T.J. Crowder
– T.J. Crowder, Commented Apr 12, 2019 at 14:24

TheMaster · Accepted Answer · 2019-04-12 14:56:20Z

1

Try

var output = one.map(function(e,i){
  return [e].concat([two, three, four].map(function(f){
    return f[i] === undefined ? '': f[i];
  }))
})
console.info(output);

edited Apr 12, 2019 at 14:56

answered Apr 12, 2019 at 14:41

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

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

Comments

T.J. Crowder · Accepted Answer · 2019-04-12 14:39:04Z

JavaScript doesn't have multi-dimensional arrays, it has arrays of arrays.

If you don't already have the one, two, three, four arrays, you can do it with a single nested literal:

var result = [
    ["apple", "fobar", 13, "seven"],
    ["banana", "barfoo", 421, "eight"],
    ["berry", undefined, "eleven"]
];

Live Example:

var result = [
    ["apple", "fobar", 13, "seven"],
    ["banana", "barfoo", 421, "eight"],
    ["berry", "farboo", undefined, "eleven"]
];
console.log(result);

.as-console-wrapper {
  max-height: 100% !important;
}

If you do already have them, since they're arrays of column values and apparently you want the subarrays to be row values, you need to loop:

var result = [];
for (var i = 0; i < 3; ++i) {
    result[i] = [
        one[i], two[i], three[i], four[i]
    ];
}

Live Example:

var one =   ["apple","banana","berry"];
var two =   ["fobar", "barfoo", "farboo"];
var three = [13, 421];
var four =  ["seven", "eight", "eleven"];
var result = [];
for (var i = 0; i < 3; ++i) {
    result[i] = [
        one[i], two[i], three[i], four[i]
    ];
}
console.log(result);

.as-console-wrapper {
  max-height: 100% !important;
}

Collectives™ on Stack Overflow

Google Sheets: Return Multi Dimensional Array (JavaScript)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related