E1:=INDEX($C:$C,COLUMN(A1)+ROW(A1)*3-3)
E2:=INDEX($D:$D,COLUMN(A1)+ROW(A1)*3-3)
选中E1:E2,右拉后下拉
选择性粘贴，转置
e1=index)$c:$d,roundup(column(a1)/2,0)+roundup(row(a1)/2,0)*6-6,mod(row(a1)-1,2)+1)右拉下拉
写代码可以实现
