Text Tools
Transpose custom-delimited rows and columns using any single-character delimiter.
Use this tool to transpose arbitrary delimited text so rows become columns and columns become rows. It is useful for pipe-separated, semicolon-separated, colon-separated, and other custom flat-text formats.
Use this tool to transpose arbitrary delimited text so rows become columns and columns become rows. It is useful for pipe-separated, semicolon-separated, colon-separated, and other custom flat-text formats.
Use transpose arbitrary delimited text when you need a fast browser-based result without extra setup. It works well for quick checks, one-off tasks, and routine formatting or calculation work.
Read step-by-step usage guidance, best practices, and common mistakes.
See common questions and answers about input, output, and tool usage.
Review practical input and output examples before running the tool.
Find similar and supporting tools for adjacent actions and follow-up tasks.
Input
| name|age John|30 Anna|25
Output
name|John|Anna age|30|25
Rows become columns and columns become rows.
Input
; id;title 1;Book 2;Pen
Output
id;1;2 title;Book;Pen
Useful for flipping custom-delimited tables.
Fix: Use a single-character delimiter such as ; | : or ,.
Fix: Check the original structure because shorter rows will produce empty values.
Fix: Make sure the source data really uses the delimiter you entered.
It swaps rows and columns in flat text that uses a custom single-character delimiter.
Any single character such as ; | : or ,.
Missing values become empty cells in the transposed result.
Yes. It is the same core transpose action, just described more generally.
It is useful when a custom-delimited flat table needs to be flipped quickly.