=IF(ROWS($1:1)>COUNT(A$2:A$6)*2,"",INDEX(A:A,MOD(ROW(A5),5)+2))
=INDEX(B$1:C$1,INT(ROW(A5)/5))
=INDEX(B:C,MOD(ROW(A5),5)+2,INT(ROW(A5)/5))
=INDEX(A:C,MATCH(E2,A:A,),MATCH(F2,$1:$1,))
å ¶å®ç²è´´å¤å¶ä¹å¾å¿«
本节视频我们来聊一聊如何添加数据表的行与列。Treelab 官网:www.treelab.com.cn
本回答被网友采纳