隔指定行数插入1空行求助

流住我

要求：根据g3指定的行数的数值5在c4：c103的文本按照每隔5行插入h3的控行数值1的行数得得到d4：d122的结果，
根据g3指定的行数的数值10，在c4：c103的文本按照每隔,10行插入h3的控行数值1的行数得得到e4：e122的结果，
g3的数字可以调节的，是动态变化的
请各位老师在d4：d122和e4：e122里加上函数，多谢！

良良

=OFFSET(C$3,1+G$3*(INT((G$3+H$3+ROW(A1)-1)/(G$3+H$3))-1)+TEXT(MOD(ROW(A1)-1,G$3+H$3),"[>="&G$3&"]999"),)&""

huihuang6669

1. =LET(s,C4:C103,f,LAMBDA(x,y,TEXTSPLIT(TEXTJOIN(,,s&","&IF(MOD(ROW(s)-3,x),"",REPT(",",y))),,",")),f(G3,H3))

复制代码

A九月

=DROP(REDUCE("",UNIQUE(ROUNDUP(SEQUENCE(ROWS(C4:C103))/5,0)),LAMBDA(X,Y,VSTACK(X,FILTER(C4:C103,ROUNDUP(SEQUENCE(ROWS(C4:C103))/5,0)=Y),""))),1)



5是个变量，要多少行就改变5可以了

fgq5910

D4=IF(
    MOD(ROW()-ROW($D$4),$G$3+$H$3)<=$G$3-1,
    INDEX($C$4:$C$103, ROW()-ROW($D$4)+1-INT((ROW()-ROW($D$4))/($G$3+$H$3))*$H$3),
    ""
)
E4=IF(
    MOD(ROW()-ROW($E$4),$G$3+$H$3)<=$G$3-1,
    INDEX($C$4:$C$103, ROW()-ROW($E$4)+1-INT((ROW()-ROW($E$4))/($G$3+$H$3))*$H$3),
    ""
)

fgq5910

D4=IF(MOD(ROW(A1)-1,6)<5,INDEX($C$4:$C$103,INT((ROW(A1)-1)/6)*5+MOD(ROW(A1)-1,6)+1),"")
E4=IF(MOD(ROW(A1)-1,11)<10,INDEX($C$4:$C$103,INT((ROW(A1)-1)/11)*10+MOD(ROW(A1)-1,11)+1),"")

fgq5910

动态（引用G3和H3）：
=IF(MOD(ROW(A1)-1,$G$3+$H$3)<$G$3,INDEX($C$4:$C$103,INT((ROW(A1)-1)/($G$3+$H$3))*$G$3+MOD(ROW(A1)-1,$G$3+$H$3)+1),"")