使用IMPORTRANGE将多个电子表格合二为一 [英] Combining multiple spreadsheets in one using IMPORTRANGE

问题描述

我想将多个电子表格的数据汇总到一个电子表格中.

I would like to aggregate the data of multiple spreadsheets into one spreadsheet.

• 电子表格1包含一行字符串A2:A500
• 电子表格2包含一行字符串A2:A500
• 电子表格3应该具有两个行(Spreadsheet1！A2:A500和Spreadsheet2！A2:A500).

重复项不应以不同的方式处理.我希望它们出现的频率与它们在不同工作表中出现的频率一样.

Duplicates shall not be handled differently. I would like them to appear as often as they appear in the different sheets.

是否可以在不编写脚本或不使用jQuery的情况下执行此操作，例如通过使用IMPORTRANGE?

Is it possible to do this without writing a script or using jQuery, e.g. by using IMPORTRANGE?

什么不起作用:我尝试如下使用IMPORTRANGE:

What does not work: I have tried using IMPORTRANGE as follows:

ARRAY{IMPORTRANGE("key-of-spreadsheet1","list!A2:A500"), IMPORTRANGE("key-of-spreadsheet2", "list!A2:A500")}

这会导致错误.

推荐答案

您应该能够在电子表格3 中使用垂直数组:

You should be able to use a vertical array in the Spreadsheet 3:

={IMPORTRANGE("Sheet1Key","SheetName!A2:A500");IMPORTRANGE("Sheet2Key","SheetName!A2:A500")}

这篇关于使用IMPORTRANGE将多个电子表格合二为一的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！