H1右拉 下拉=IFERROR(IF(ROW(A1)>10^SUM(LOG(LEN(T(OFFSET($A$1,COLUMN(A1)-1,{1,2,3}))))),"",MID(OFFSET($B$1,COLUMN(A1)-1,),INT((ROW(A1)-1)/10^SUM(LOG(LEN(T(OFFSET($A$1,COLUMN(A1)-1,{2,3})))))+1%%)+1,1)&MID(OFFSET($C$1,COLUMN(A1)-1,),MOD(INT((ROW(A1)-1)/LEN(T(OFFSET($D$1,COLUMN(A1)-1,)))+1%%),LEN(T(OFFSET($C$1,COLUMN(A1)-1,))))+1,1)&MID(OFFSET($D$1,COLUMN(A1)-1,),MOD(ROW(A1)-1,LEN(T(OFFSET($D$1,COLUMN(A1)-1,))))+1,1)),"")
留言
張貼留言