Matrix transposition: Difference between revisions
→{{header|Excel}}: Added an Excel example.
m (→JS ES6: Defined transposition of empty matrix) |
(→{{header|Excel}}: Added an Excel example.) |
||
Line 1,461:
{4,8,12}
}</pre>
=={{header|Excel}}==
Excel has a built-in TRANSPOSE function:
{| class="wikitable"
|-
|||style="text-align:right; font-family:serif; font-style:italic; font-size:120%;"|fx
! colspan="9" style="text-align:left; vertical-align: bottom; font-family:Arial, Helvetica, sans-serif !important;"|=TRANSPOSE(F2#)
|- style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff;"
|
| A
| B
| C
| D
| E
| F
| G
| H
| I
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 1
|
| colspan="3" style="text-align:left; font-weight:bold" | Transposed
|
| colspan="4" style="text-align:left; font-weight:bold" | Source matrix
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 2
|
| style="text-align:center; background-color:#cbcefb" | 1
| style="text-align:center" | 5
| style="text-align:center" | 9
|
| style="text-align:center" | 1
| style="text-align:center" | 2
| style="text-align:center" | 3
| style="text-align:center" | 4
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 3
|
| style="text-align:center" | 2
| style="text-align:center" | 6
| style="text-align:center" | 10
|
| style="text-align:center" | 5
| style="text-align:center" | 6
| style="text-align:center" | 7
| style="text-align:center" | 8
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 4
|
| style="text-align:center" | 3
| style="text-align:center" | 7
| style="text-align:center" | 11
|
| style="text-align:center" | 9
| style="text-align:center" | 10
| style="text-align:center" | 11
| style="text-align:center" | 12
|-
| style="text-align:center; font-family:Arial, Helvetica, sans-serif !important; background-color:#000000; color:#ffffff" | 5
|
| style="text-align:center" | 4
| style="text-align:center" | 8
| style="text-align:center" | 12
|
|
|
|
|
|}
=={{header|F_Sharp|F#}}==
| |||