IMPORTRANGE将多个Google表格导入到一个垂直列中？ [英] IMPORTRANGE to import multiple Google Sheets into one vertical column?

问题描述

我在使用Google表格中的IMPORTRANGE时遇到了一些问题，要将多个工作表导入到主工作表中的单个列中，并且只要更新了其中一个工作表，它就会自动在主服务器上创建新行。除了IMPORTRANGE之外，还有更好的方法吗？

解决方案

您可以使用嵌入式数组将数组相互连接。了解更多：

要在另一个数组顶部附加一个数组，您可以使用分号; ;而不是逗号，。就像这样： = {1; 2; 3; 4} 它看起来像这样：

要将多个数组附加在一起，您需要一个数组 {1; 2; 3; 4} 并将其附加到另一个，如： {1; 2; 3; 4}; {5; 6; 7; 8} ，并用嵌入式数组语法如下所示：

  {{1; 2; 3; 4}; {5; 6; 7; 8} } 
  

然而，一个严格的限制是两个数组都需要是同样的宽度，所以如果你有 {{1,2}; {1,2}; {1,2,3}} 你会收到一个错误，因为不是所有的数组元素具有相同的列数。

如何将多个范围相互导入？

使用上述概念，假设 IMPORTRANGE（）的宽度是相同的：

  = {IMPORTRANGE（sheet，range）; IMPORTRANGE（sheet，range）} 
  

将导入两个范围一个在另一个之上。

I am having a bit of an issue using IMPORTRANGE in Google Sheets to import multiple sheets into a single column on a master sheet and whenever one of the sheets is updated, it automatically creates the new row on the master. Would there be a better way to do it other than IMPORTRANGE?

解决方案

You can attach arrays onto each other by using embedded arrays. See more: Using arrays in Google Sheets

This is a basic array ={1,2,3,4} and has an output that looks like this:

To append an array on-top of another array you would use a semicolon ;; instead of a comma ,. Like so: ={1;2;3;4} which will look like this:

To append multiple arrays together you would take one array {1;2;3;4} and append it to another like: {1;2;3;4};{5;6;7;8} and encase both with the embedded array syntax like so:

{{1;2;3;4};{5;6;7;8}}

However, one strict limitation is that both arrays need to be the same width, so if you have {{1,2};{1,2};{1,2,3}} you will receive an error becuase not all the array elements have the same number of columns.

How to import multiple ranges on top of each other?

Using the above concepts, assuming both IMPORTRANGE()'s are the same width:

={IMPORTRANGE(sheet, range);IMPORTRANGE(sheet, range)}

Will import two ranges one on top of the other.

这篇关于IMPORTRANGE将多个Google表格导入到一个垂直列中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！