(1)第Ⅰ种转换的公式为:
{=INDIRECT(TEXT(SMALL(IF(($A$2:$C$6<>''),ROW($A$2:$C$6)*1000+COLUMN($A$2:$C$6)),ROW(1:1)),'r0c000'),)}
(2)第Ⅱ种转换的公式为:
=INDEX($A$2:$C$6,MOD(ROW(A1)-1,5)+1,INT((ROW(A1)-1)/5)+1)
(3)第Ⅲ种转换的公式为:
=INDEX($A$2:$C$6,MOD(ROW(B1)-1,5)+1,3-INT((ROW(B
