如何将数据从一张纸导入“仅一个单元格"?在另一张纸上 [英] How to import data from one sheet to "only one cell" in another sheet

问题描述

使用Google工作表，我可以使用

Using google sheets, I am able to transfer data from one sheet to another sheet using

= IMPORTRANGE

=IMPORTRANGE

，但是IMPORTRANGE将创建更多的单元格，具体取决于您要复制多少个单元格.我只需要将工作表1中的所有数据复制到工作表2的一个单元中.有没有办法做到这一点?

but IMPORTRANGE creates more cells depending on how many cells you are copying over. I need to copy all data from sheet1 into only one cell of sheet 2. Is there a way to do that?

谢谢！

推荐答案

在授权访问外部电子表格后，请尝试

After you authorize the access to the external spreadsheet, try

=JOIN(CHAR(10),QUERY(TRANSPOSE(IMPORTRANGE(spreadsheet_key,reference_string)),,2E6))

如果源数据是

+---+----+----+
|   | A  | B  |
+---+----+----+
| 1 | A1 | B1 |
| 2 | A2 | B2 |
+---+----+----+

结果将是

+---+---------+
|   |   A     |
+---+---------+
| 1 | A1 B1   |
|   | A2 B2   |
+---+---------+

这篇关于如何将数据从一张纸导入“仅一个单元格"?在另一张纸上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！