Google电子表格 - 将多列转换为一列 [英] Google Spreadsheet - Convert multiple columns to one column
问题描述
XXX 123 234 234
YYY 789 098 765
ZZZ 76 123 345
最终结果需要:
XXX:123
XXX:234
XXX:234
YYY:789
等。
我现在的代码:
pre $ 函数loopshoplocations(){
var sheet = SpreadsheetApp.getActiveSheet();
var data = sheet.getRange('A4:A8')。getValues();
var i = 0;
for(i = 0; i <4; i ++){
return('Shop Location:'+ data [i] [0]);
}}
是第一行的标题行。数据被附加在工作表的末尾。如果你想要不同的东西,代码将需要调整。
function loopshoplocations(){
var data, L,outerArray,innerArray,numberOfRows,片材,STARTROW;
startRow = 2;
sheet = SpreadsheetApp.getActiveSheet();
numberOfRows = sheet.getLastRow();
data = sheet.getRange(startRow,1,numberOfRows-startRow + 1,4).getValues();
L = data.length;
//Logger.log(数据);
outerArray = [];
var i,j; (i = 0; i
for(j = 1; j <4; j + = 1){//从1开始计数,而不是0
innerArray = []; //重置
innerArray.push(data [i] [0]);
innerArray.push(data [i] [j]);
//Logger.log(innerArray)
outerArray.push(innerArray);
};
};
sheet.getRange(numberOfRows + 1,1,outerArray.length,outerArray [0] .length).setValues(outerArray);
};
I want to loop through a set of rows in a Google Spreadsheet that look like this:
XXX 123 234 234
YYY 789 098 765
ZZZ 76 123 345
End Result Needs to Be:
XXX: 123
XXX: 234
XXX: 234
YYY: 789
YYY: 098
etc.
My current code:
function loopshoplocations(){
var sheet = SpreadsheetApp.getActiveSheet();
var data = sheet.getRange('A4:A8').getValues();
var i=0;
for(i = 0; i < 4; i++){
return ('Shop Location: ' + data[i][0]);
}}
This code assumes that there is a header row on row one. The data gets appended at the end of the sheet. If you want something different, the code would need to be adjusted.
function loopshoplocations() {
var data,L,outerArray,innerArray,numberOfRows,sheet,startRow;
startRow = 2;
sheet = SpreadsheetApp.getActiveSheet();
numberOfRows = sheet.getLastRow();
data = sheet.getRange(startRow,1,numberOfRows-startRow+1,4).getValues();
L = data.length;
//Logger.log(data);
outerArray = [];
var i,j;
for(i = 0; i < L; i++){
for (j=1; j<4 ; j+=1) {//Begin count at one, not zero
innerArray = [];//Reset
innerArray.push(data[i][0]);
innerArray.push(data[i][j]);
//Logger.log(innerArray)
outerArray.push(innerArray);
};
};
sheet.getRange(numberOfRows+1,1,outerArray.length,outerArray[0].length).setValues(outerArray);
};
这篇关于Google电子表格 - 将多列转换为一列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!