Matrix transposition: Difference between revisions
Content added Content deleted
m (→JS ES6: Defined transposition of empty matrix) |
(→{{header|Excel}}: Added an Excel example.) |
||
Line 1,461: | Line 1,461: | ||
{4,8,12} |
{4,8,12} |
||
}</pre> |
}</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#}}== |
=={{header|F_Sharp|F#}}== |