How-to · Table Formatter

Transpose Table Rows and Columns Online Without Losing Formatting

How to transpose table rows and columns instantly in your browser while preserving cell store attributes and applied CSS utility classes.

Open Table Formatter Add to VS Code
Free · runs in your browser · your files are never uploaded

TLDR

Flipping rows and columns (matrix transposition) in traditional spreadsheets often destroys cell formulas, cell merges, and CSS formatting styles. GINEXYS Table Formatter (TAFNE) Table Mode provides a one-click Transpose command that flips horizontal and vertical axes instantly, maintaining underlying cell IDs, applied CSS classes, and export formatting.

The Search Query: Online Table Transpose Tool

Financial report authors search for:

Axis Transposition Engine Mechanics

When you click Transpose, TAFNE flips the coordinate matrix $[r, c] \to [c, r]$, adjusting table dimension bounds and remapping cell attributes:

// Table matrix transposition signature in core TableEditor.js
import { transposeTable } from '../core/TableEditor.js';

const transposed = transposeTable(activeSheet);

// Result: Row 1 becomes Column 1, Row 2 becomes Column 2... console.log(Flipped grid dimensions to ${transposed.rowCount} rows x ${transposed.colCount} cols.);

Rule of thumb: use a cell store coordinate remapper when transposing tables to preserve applied CSS utility classes across axes.

Applied CSS Class Preservation

Unlike spreadsheet cut-and-paste transposition, TAFNE retains all visual CSS tags (freeze-pane, highlighted, accordion-header):

<!-- Output HTML table after 1-click transpose pass -->
<table class="tafne-table">
  <thead>
    <tr>
      <th class="freeze-pane">Metric</th>
      <th>Q1</th>
      <th>Q2</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td class="highlighted">Revenue</td>
      <td>$100k</td>
      <td>$140k</td>
    </tr>
  </tbody>
</table>

Conclusion

One-click matrix transposition allows report authors to toggle between horizontal and vertical data views instantly without breaking web styling.

Table Formatter — Clean, reshape, and convert tabular data between HTML, CSV, TSV, SQL, and Markdown.