Sometimes a table is the right data in the wrong shape. You exported a report with one row per metric, but the chart you want needs each metric as a column. Or a survey came back wide when your analysis tool expects it tall. Transposing flips the table so the rows and columns trade places.
The short version: paste your table or drop in a file, and get the flipped version to copy or download. The transpose tool runs on your device, so nothing is uploaded.
What transposing means in practice
Transposing rotates a table around its diagonal. Every row becomes a column and every column becomes a row. If your first column was a list of labels running down the page, after transposing it becomes the header row running across the top.
A small example makes it concrete. This table:
| metric | jan | feb |
|---|---|---|
| revenue | 100 | 120 |
| cost | 40 | 45 |
becomes:
| metric | revenue | cost |
|---|---|---|
| jan | 100 | 40 |
| feb | 120 | 45 |
The numbers are the same; only their arrangement changed. And because transposing is its own inverse, running it again returns the original, so there is no risk of getting stuck in the wrong layout.
Why you would do this
The reason is almost always that another tool wants the data the other way round. Charting libraries and pivot tables usually expect each variable in its own column and each observation in its own row. A “long” export with everything stacked in rows has to be turned on its side first. Transposing is the one-step way to do that without retyping anything.
How to transpose a table
Step 1: Add your data
Paste CSV text into the tool, or drop in a .csv or Excel file. The first sheet is used.
Step 2: Check the preview
The flipped table appears immediately. Confirm the labels you expected at the top are now across the top, and the values line up.
Step 3: Copy or download
Copy the result as CSV to paste elsewhere, or download a real Excel workbook built from the transposed table.
Related reshaping
Transposing changes the orientation of the whole table. If instead you only need certain columns, in a certain order, extracting columns does that without flipping anything. And once the shape is right, you can turn the result into a typed workbook with the CSV to Excel converter.