JavaScript / Google Script - Transpose "Row" Array into "Column" Array

Question

Good afternoon,

I am attempting transpose a "row" array (or 1D array) into a "column" array (or array that is one array containing individual arrays within it) to allow me to set values to a single column (downward multiple rows) instead if it being one row across multiple columns

I attempted using a push loop and a map function but neither attempt succeeded:

function myFunction2() {

  var ss=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Source1");

  var lastColumn = ss.getLastColumn()

  var endRange = lastColumn-3

  //Retrieve values into array named "items"
  var items = ss.getRange(16,4,1,endRange).getValues()

Transpose attempt # 1:

  var colArray = [];
    for (var i=0; i<items.length; i++)
    {
      colArray.push([items[i]]);
    }
}

Output for Attempt # 1:

[[[item1, item2, item3, item4, item5]]]

Transpose attempt # 2:

  var colArray = items.map(function (el){
      return [el];
  });

Output for attempt # 2:

[[[item1, item2, item3, item4, item5]]]

The intended output I would like to have is:

[[item1], [item2], [item3], [item4], [item5]]

Would there be a way to achieve the intended output?

Transpose attempt #2 works and outputs as your intended output: jsfiddle.net/z5kj17wa — bbailes
– bbailes, Commented Mar 11, 2021 at 0:59

Tanaike · Accepted Answer · 2021-03-11 00:55:40Z

1

In your script of var items = ss.getRange(16,4,1,endRange).getValues(), items is 2 dimensional array like [[value1, value2, value3,,,]]. So, when your script is modified, it becomes as follows.

From:

  var colArray = [];
    for (var i=0; i<items.length; i++)
    {
      colArray.push([items[i]]);
    }
}

To:

var colArray = [];
for (var i = 0; i < items[0].length; i++) {
  colArray.push([items[0][i]]);
}

And,

From:

var colArray = items.map(function (el){
    return [el];
});

To:

var colArray = items[0].map(function (el){
  return [el];
});

Note:

Or, when you want to transpose the values including the several rows and columns, you can also use the following script.
```
  const colArray = items[0].map((_, i) => items.map(row => row[i]));
```

References:

map()

answered Mar 11, 2021 at 0:55

Tanaike

203k12 gold badges126 silver badges222 bronze badges

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

Collectives™ on Stack Overflow

JavaScript / Google Script - Transpose "Row" Array into "Column" Array

1 Answer 1

From:

To:

From:

To:

Note:

References:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

From:

To:

From:

To:

Note:

References:

Comments

Your Answer

Sign up or log in

Post as a guest

Related