合并多个表 [英] Merge multiple tables

问题描述

我有很多表格来描述我的小公司的不同种类的支出和收益，而且我发现像这样的示例中的合并表的方法不容易:

I have lots of sheets describing different kind of expenses and gains of my small company, and I find no easy way to merge my tables like in this example I made:

我希望在更新其他表格时自动用其他表格的行填充最后一张表格，这样我可以预见费用和时间的增加(通过按日期升序自动排序绿色表格).

I want the last table to be auto filled with the lines of the others tables when I update them, so I can foresee the expenses and gain in time (by ordering the green table automatically by date ascending).

现在，我发现的唯一临时解决方案是预先将引用复制到合并表(绿色)中的其他表行(黄色和蓝色).

By now the only temp solution I found is to copy references to the other tables lines (yellow and blue) in the merging table (green) in advance.

数据透视表不允许在多个表上实现这种收集.

Pivot tables do not permit to achieve this kind of gathering on several tables.

推荐答案

在单元格I2中使用以下查询公式:

Use this Query formula in cell I2:

=QUERY({A2:C; E2:G}, "select * where Col1 is not null", 1)

要同时按日期排序，请按以下顺序添加订单:

To also order them by Date, add the order by:

=QUERY({A2:C; E2:G}, "select * where Col1 is not null order by Col1", 1)

这篇关于合并多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！