如果具有动态数组公式FILTER:

If one has the Dynamic Array Formula FILTER:

=FILTER({1,2,3},TRANSPOSE({TRUE;FALSE;TRUE}))

没有动态数组公式:

=TRANSPOSE(MODE.MULT(IF({TRUE;FALSE;TRUE},ROW(1:3)*{1,1})))

这是一个数组公式，取决于版本，在退出编辑模式时可能需要按Ctrl-Shift-Enter确认.

This is an array formula and depending on ones version, it may need to be confirmed with Ctrl-Shift-Enter when exiting edit mode.