轉置行列 (15397)

G1 右拉=IF(COLUMN(A1)>$E2*4,"",CHOOSE(MOD(COLUMN(A1)-1,4)+1,"序号","姓名","簽名",""))

G2右拉 下拉=IF((ROW(A1)>ROUNDUP(COUNT($B:$B)/$E$2,))+(MOD(COLUMN(A1)-1,4)>1)+(G$1=""),"",OFFSET($A$1,ROW(A1)+ROUNDUP(COUNT($B:$B)/$E$2,)*INT(COLUMN(A1)/4),MOD(COLUMN(A1),4))&"")