如何把四列数据排列成一列

2087788

如何把四列数据排列成一列，用EXCEL公式，EXCEL版本2016

袁勇

1. =IFERROR(INDIRECT(TEXT(MOD(AGGREGATE(15,6,(COLUMN(D:G)*1000001+ROW($2:$10)*100)/(D$2:G$10<>""),ROW(A1)),10000),"r0c00"),),"")

复制代码

2087788

袁勇 发表于 2024-6-24 16:44

，感谢，帮我大忙了

hugeinfo

=TOCOL(IF(D2:G7<>"", D2:G7,x),3,TRUE)

624134745

hugeinfo 发表于 2024-6-24 17:50
=TOCOL(IF(D2:G7"", D2:G7,x),3,TRUE)

你别高版本硬上呀，楼主说了2016

hcm19522

D3:D8{=INDEX(A:A,SMALL(IF($B$2:$B$30>500,ROW($A$2:$A$30),99),ROW(A1)))&""

E3:F8{=INDEX($A:$A,SMALL(IF(MMULT(N($B$2:$B$30-LEFT(D$2:E$2,FIND("以",D$2:E$2)-1)>0),{1;1})=1,ROW($2:$30),99),ROW(A1)))&""

G3:G8{=INDEX(A:A,SMALL(IF($B$2:$B$30<50,ROW($A$2:$A$30),99),ROW(A1)))&""

I2:I23{=IFERROR(INDIRECT(TEXT(RIGHT(SMALL(IF(D$2:G$8<>"",COLUMN(D:G)*10001+ROW($2:$8)/1%),ROW(A1)),4),"!R0C00"),),"")

hugeinfo

624134745 发表于 2024-6-24 17:51
你别高版本硬上呀，楼主说了2016

=INDIRECT(TEXT(RIGHT(SMALL(IF($D$2:$G$7<>"",COLUMN($D:$G)*1001+ROW($2:$7)/1%),ROW(A1)),3),"r0c00"),FALSE)