横向的数据，改成纵列来显示，金额为的0数据不需要

橒♂蝣

=LET(x,CHOOSE({1,2,3,4},$B$3:$B$8&";"&$C$2&";"&$C$3:$C$8,$B$3:$B$8&";"&$D$2&";"&$D$3:$D$8,$B$3:$B$8&";"&$E$2&";"&$E$3:$E$8,$B$3:$B$8&";"&$F$2&";"&$F$3:$F$8),
y,INDEX(x,INT(ROW(A4:A27)/4),MOD(ROW(A4:A27),4)+1),
z,TRIM(MID(SUBSTITUTE(y,";",REPT(" ",99)),COLUMN(A1:C1)*99-98,99)),
FILTER(z,INDEX(z,,3)<>"0")
)

minchar

偷个鸡
=FILTER(TEXT({1,-1,0},TOCOL(""""&B3:B8&""";"&C2:F2&";"&C3:F8)),TOCOL(C3:F8)>0)

alan57

1. =REDUCE(H2:K2,ROW(1:6),LAMBDA(x,y,LET(_a,TOCOL(OFFSET(B2,y,1,,4),3),_b,CHOOSE({1,2,3},OFFSET(B2,y,),TOCOL(OFFSET(B2,,1,,4),3),_a),_c,FILTER(_b,TAKE(_b,,-1)>0),VSTACK(x,HSTACK(SEQUENCE(ROWS(_c),,ROWS(x)),_c)))))

复制代码