轉置 成條子式 (9893)

A1:E1 右拉 下拉=IF(MOD(COLUMN(A1),3),IFERROR(MID("姓名编号部门职务",MOD(ROW(A1),5)*2-1,2)&"："&OFFSET($F$1,COLUMN(A1)-(COLUMN(A1)>2)+INT(ROW(A1)/5)*4,MOD(ROW(A1),5)),""),"")