...将其转置后,变成4行3列的矩阵输出。这个c语言的代码咋写答:int main(void){ int a[3][4] = {11,12,13,14,21,22,23,24,31,32,33,34};int b[4][3];int i, j;for(i=0; i<4; i++) //转置数组;for(j=0; j<3; j++)b[i][j] = a[j][i];for(i=3; i>=0; i--) //反向输出转置后的数组;{ for(j=2; j>=0; j-...
用indirect函数将三列四行转置成单列十二行或两列六行答:TEXT(RIGHT(SMALL(IF($A$2:$C$5<>"",ROW($2:$5)*10+COLUMN($A:$C)*10001,99999),ROW(A1)),3),"r0c0"),)&""公式2=INDIRECT(TEXT(RIGHT(SMALL(IF($A$2:$C$5<>"",0+(ROW($2:$5)&COLUMN($A:$C)),99999),ROW(A1)),3),"r0c0"),)&""注意两个都是数组公式 ...