如何將 3 個不同的工作表與 Query(importrange) 結合起來？ (How to combine 3 different sheets with Query(importrange)?)

問題描述

如何將 3 個不同的工作表與 Query(importrange) 結合起來？ (How to combine 3 different sheets with Query(importrange)?)

我正在嘗試使用 Query(IMPORTRANGE 函數組合來自 A2:O Col1、Col4、Col5、Col6、Col8、Col11、Col12、Col13、Col14、Col15 範圍的 3 張不同的數據表。我嘗試使用下面的公式，但它說

formula parse error

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

參考解法

方法 1:

It doesn't like the final semicolon after the third importrange. If I take this out, then I just get another error because I can't access your sheet:

=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 )

(by Keanson Ye、Tom Sharpe)

參考文件

1. How to combine 3 different sheets with Query(importrange)? (CC BY‑SA 2.5/3.0/4.0)