我有一個按日期排序的患者串列（或手動插入到列的末尾）：
或者
請幫忙。這是我需要的演示：
uj5u.com熱心網友回復：
更高級的東西：
=INDEX(IFERROR(VLOOKUP(SUBSTITUTE(D2:D, " ", CHAR(13)),
SPLIT(FLATTEN(TRIM(QUERY(REGEXREPLACE(SUBSTITUTE(QUERY({
FILTER(TEXT(ROW(A2:A), "000000")&"×"&A2:A, A2:A<>""), ARRAY_CONSTRAIN(FLATTEN(TRANSPOSE(
FILTER(TEXT(ROW(D2:D), "000000")&"×"&D2:D, D2:D<>"")&T(SEQUENCE(1,
ROUNDUP(COUNTA(A2:A)/COUNTA(D2:D)))))), COUNTA(A2:A), 2)},
"select max(Col1) group by Col1 pivot Col2"), " ", CHAR(13)),
"^(\d ×)", ),,9^9))), " "), SEQUENCE(1, ROUNDUP(COUNTA(A2:A)/COUNTA(D2:D)), 2), 0)))
演示電子表格
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/340846.html
上一篇：打造鏈上Bloomberg