如何合并来自使用同一模板的不同工作表中的数据? [英] How to merge data from different sheets that use the same template?

问题描述

我有一个包含5张纸的电子表格

I have one spreadsheet which has 5 sheets

所有工作表共享相同的模板，因此它们是相似的.唯一的区别是数据

All the sheets share the same template, so they are alike. The only difference is the data

我想制作另一个工作表，它从工作表1,2,3,4,5中的A3列(从第3行到最后)获取所有数据，并将其放在新工作表的1列中.

I would like to make another sheet, whichs gets all the data from column A3 (from row 3 to the end) in sheet 1,2,3,4,5, and puts it in 1 column in my new sheet.

这怎么可能?

我正在使用Google文档，但我想Excel和Google文档非常相似.

I am using Google Docs, but i guess Excel and Google Docs are much alike.

谢谢

推荐答案

=CONCATENATE(Sheet1!A:A,",",Sheet2!A:A,",",Sheet3!A:A,",",Sheet4!A:A,",",sheet5!(A:A)) 这将连接 1-5页的A1，A1，A1，A1，A1在表格6上.将其向下拖动以按单元格连接(A2，然后是A3).您无需定义范围A:A，但可以定义.

=CONCATENATE(Sheet1!A:A,",",Sheet2!A:A,",",Sheet3!A:A,",",Sheet4!A:A,",",sheet5!(A:A)) This will concatenate A1,A1,A1,A1,A1 for sheets 1-5 on sheet 6. Drag it down to concatenate by cells (A2 then A3). You don't need to define the ranges A:A but you can if you want.

这篇关于如何合并来自使用同一模板的不同工作表中的数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！