Convert pipe-separated rows to columns
Input
| name|age John|30 Anna|25
Output
name|John|Anna age|30|25
Turns normal row-based custom-delimited text into horizontal columns.
Text Tools
Review practical Convert Arbitrary Delimited Text Rows to Columns examples so you can understand expected input, output, and common patterns faster.
Use this tool to turn row-oriented arbitrary delimited text into column-oriented output. It is useful when custom-separated flat data needs to become horizontal for compact display, summaries, or another layout.
Example pages are especially useful for text tools because they show what good input looks like, what kind of output to expect, and how the tool behaves in common scenarios.
Input
| name|age John|30 Anna|25
Output
name|John|Anna age|30|25
Turns normal row-based custom-delimited text into horizontal columns.
Input
; id;title 1;Book 2;Pen
Output
id;1;2 title;Book;Pen
Useful for compact custom-separated summaries.
Fix: Use a single-character delimiter.
Fix: Check the source text because missing fields will show up as blanks.
Fix: Make sure the input really uses the delimiter you entered.
After reviewing these examples, run the live tool with your own input. If your task involves a follow-up step, the related page can help you move to the next tool in the workflow.
Open the main Convert Arbitrary Delimited Text Rows to Columns page and test your own real input.