google-sheets - Google Sheets - 从一个范围内重复值 'n' 次

Question

我试图通过重复一系列单元格中的某些单元格值(重复次数)并水平迭代直到行尾，在谷歌工作表中执行以下操作。

用于电流输出的公式:

={ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(QUERY(REPT(A1&",",A2:A4 ), ,999^99), ","))));ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(QUERY(REPT(C1&",",C2:C4 ), ,999^99), ","))));ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(QUERY(REPT(E1&",",E1:E4 ), ,999^99), ","))))}

Answer 1

用:

=ARRAYFORMULA(FLATTEN(SPLIT(TEXTJOIN("×", 1, 
 REPT({A1&"×", C1&"×", E1&"×"}, {A2:A, C2:C, E2:E})), "×")))

更短:

=INDEX(FLATTEN(SPLIT(TEXTJOIN("×", 1, 
 REPT({A1, C1, E1}&"×", {A2:A, C2:C, E2:E})), "×")))

更新:

=INDEX(QUERY(FLATTEN(SPLIT(QUERY(FLATTEN(QUERY(FLATTEN(
 REPT("×"&{A1, C1, E1}&"×", {A2:A, C2:C, E2:E})),,9^9)),,9^9), "×")), 
 "where not Col1 starts with ' '"))