在Google工作表的查询结果末尾追加文本

Question

你好，我有一个正在运行两个查询的函数。我想把字母E加到第一个查询结果的末尾，把字母B加到查询结果的末尾。

我当前的功能是

={QUERY(importRange("*****", "'Inventory'!A3:D"), "SELECT Col2 WHERE ((Col3) > 0)", 1);QUERY(importRange("******", "'Inventory'!A3:D"), "SELECT Col2 WHERE ((Col4) > 0)", 1)}

Answer 1

use:

=ARRAYFORMULA({QUERY(IMPORTRANGE(
"1FpeC9Nck7aGjTEoHg5R0QQBC4S5zj4Yiu_-p0AjvqXY", "'Inventory'!A3:D"), 
"select Col2 where Col3 > 0", 1)&"E"; QUERY(IMPORTRANGE(
"1FpeC9Nck7aGjTEoHg5R0QQBC4S5zj4Yiu_-p0AjvqXY", "'Inventory'!A3:D"), 
"select Col2 where Col4 > 0", 1)&"B"})