如何将 3 个不同的工作表与查询(导入范围)组合?

Question

我正在尝试使用Query(IMPORTRANGE函数组合范围 A3：O Col1、Col4、Col5、Col6、Col8、Col11、Col12、Col13、Col14、Col15 中的 2 张不同的数据表。我尝试使用下面的公式，但它说

公式分析错误

https://docs.google.com/spreadsheets/d/1ECEMY6zdrIHrtJhvwLm0XnyP4AYOp4YnZ_bp9azLNyM/edit?usp=sharing

=QUERY( 
{ 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'Termination Review'!A2:O"); 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'2nd Week Warning'!A2:O"); 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'In Review'!A2:O"); }, 
"Select Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 ORDER BY Col1 ASC",1 )

Answer 1

它不喜欢第三个导入范围之后的最后一个分号。如果我把它拿出来，那么我只会得到另一个错误，因为我无法访问你的工作表：

=QUERY( 
{ 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'Termination Review'!A2:O"); 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'2nd Week Warning'!A2:O"); 
IMPORTRANGE("11Vm7p_0Tx_DI649kdrHuxMaK5wauuI281175hfwBqRo", "'In Review'!A2:O") }, 
"Select Col1, Col4, Col5, Col6, Col8, Col11, Col12, Col13, Col14, Col15 ORDER BY Col1 ASC",1 )