Transpose rows and columns when you want to turn the table sideways while keeping its cell relationships. Use Transpose Rows and Columns for that orientation change. An unpivot performs a different reshape: it creates repeated records with a field naming the former value column.
Picture the output before selecting a mode
For an illustrative source with headings name, age and city, plus rows Ana/30/Bristol and Lee/25/Leeds, a transpose can produce name,Ana,Lee, then age,30,25, then city,Bristol,Leeds. Each original column has become a line.
Paste the table or select its UTF-8 file, confirm whether the first row contains headings and choose the intended transpose mode. Read the header treatment carefully because including a heading row as ordinary data changes the result's layout.
This operation does not create a new row per person and measurement. If you want columns such as person, measure and value, use Dataset Unpivot Tool instead. Write a small target example before changing a large table if the difference is unclear.
Verify cell identity, not just the dimensions
The transpose tool treats cells as text. An identifier 0012 remains 0012 in the exported data, and numeric-looking values are not rounded. Check one cell near each corner of the source to confirm the orientation is what you intended.
A spreadsheet may still infer types when you open the download. Import an identifier column as text if leading zeros matter. The tool preserving its text does not force another application to use the same import policy.
Formula protection adds an apostrophe to formula-like exported cells by default. Keep it enabled for ordinary inspection, and account for that protective change if a later system compares the exact stored text.
Keep the reshaped width manageable
The source is limited to two hundred columns and two hundred physical rows including a header. Transposing a tall table creates a wide output, so splitting a source into sensible sections may be more useful than stretching one enormous table sideways.
Table Format Converter helps when you need a different supported table representation after deciding the shape. Changing CSV to another representation does not itself perform the transpose.
Download the complete result and compare its dimensions with the source. A simple transpose should exchange the relevant axes; any selected header convention should explain the apparent extra line or column. Retain the original table so that a display-oriented change does not become your only copy of the source records.