Data Transpose help

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

Steps

  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.

Everything runs in your browser. Nothing you enter or drop is uploaded.

Back to Data Transpose