Text Tools
Convert custom-delimited columns into rows by transposing the text.
Use this tool to turn column-oriented arbitrary delimited text into row-oriented output. It is useful when custom-separated data is arranged horizontally and needs to become vertical for review, import, or reporting.
Use this tool to turn column-oriented arbitrary delimited text into row-oriented output. It is useful when custom-separated data is arranged horizontally and needs to become vertical for review, import, or reporting.
Use convert arbitrary delimited text columns to rows 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|John|Anna age|30|25
Output
name|age John|30 Anna|25
Useful when fields were originally arranged horizontally.
Input
; id;1;2 title;Book;Pen
Output
id;title 1;Book 2;Pen
Turns horizontal custom-separated data back into normal rows.
Fix: Use a single-character delimiter.
Fix: Check the source text because shorter rows will produce empty cells.
Fix: Make sure the input really uses the delimiter you entered.
It transposes custom-delimited text so columns become rows.
It uses the same core action, but this page is framed specifically for the columns-to-rows intent.
Any single character such as ; | : or ,.
Missing values become empty cells after conversion.
It is useful when custom-delimited data is arranged horizontally and needs to become vertical.