Convert Rows to Columns
Transpose delimited data so rows become columns and back.
Converters Runs in your browser
How do you convert rows to columns?
Transposing flips a table across its diagonal: the value at row 2, column 5 moves to row 5, column 2, so headers running across the top end up running down the side. Choose your data’s delimiter from the picker, then paste. Ragged rows are padded with empty cells so nothing drifts out of alignment, and running the tool twice on a rectangular grid restores the original layout.
How to use the Rows to Columns
- 1 Line up your data one row per line in the input.
- 2 Set the delimiter picker to whatever separates your cells.
- 3 The grid flips: first row down the first column.
- 4 Copy the transposed table out.
What you can use it for
- Flipping a table that was built the wrong way round.
- Turning a horizontal list into a vertical column.
- Reshaping data before pasting it into a sheet.
- Swapping headers down a column into a single row.
Frequently asked questions
What exactly moves where?
Cell (r, c) lands at (c, r). The whole table reflects across its diagonal, turning the top row into the leftmost column.
My rows are uneven; is data lost?
No. Short rows are padded with empty cells before the flip, so every value keeps its logical position and the output stays rectangular.
How do I flip it back?
Transpose again. Applied twice to a rectangular grid, the operation returns the exact original table.
Related tools
More Converters
More tools like this:
All Converters