About Data Transpose

Data Transpose takes delimited text and swaps its axes: the first row becomes the first column, and so on.

It parses quoted fields that contain the delimiter, pads short rows so the grid stays rectangular, and can change the delimiter on output. It runs in your browser.

How to use it

  1. Paste your delimited data and set the delimiter.
  2. Choose an output delimiter if you want a different one.
  3. Copy the transposed result.

Common questions

What happens to rows of different lengths?

They are padded with empty cells to match the widest row before transposing.

Are quoted fields safe?

Yes. A field wrapped in double quotes can contain the delimiter and newlines, and it is re-quoted for the output.

Is transpose reversible?

For a rectangular grid, transposing twice returns the original.