假定数据位置如图所示
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/dc54564e9258d1094b0b01d2c158ccbf6d814de2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
在F2单元格输入公式:
=IF(ROW()>COUNTA(A:A)*3-3,"",INDEX(A$2:A$100,INT((ROW()-ROW($2:$2))/3)+1))
在G2单元格输入公式:=IF(F2="","",INDEX($B$1:$D$1,MOD(ROW()-ROW($2:$2),3)+1))
在H2单元格输入公式:=IF(G2="","",INDEX(B$2:D$100,INT((ROW()-ROW($2:$2))/3)+1,MOD(ROW()-ROW($2:$2),3)+1))
选中F2:H2区域,下拉复制,直到三列全部为空。