合并单元格数值 (9301)


G2:G7=INDEX(A$3:A$4&B$2:D$2&B$3:D$4,INT(ROW(A3)/3),MOD(ROW(A1)-1,3)+1)


I2:J7{=INDEX(IF(COLUMN(A1)=1,$A$3:$A$4&$B$2:$D$2,$B$3:$D$4),INT(ROW(A3)/3),MOD(ROW(A1)-1,3)+1)


留言