Simple online tools for developers, networking, text and conversions.

Text Tools

Convert Arbitrary Delimited Text Rows to Columns

Convert custom-delimited rows into columns by transposing the text.

Tool

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.

About this tool

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.

Use convert arbitrary delimited text rows to columns 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.

Learn more

Why use this tool

How to use

  1. Put the delimiter on the first line
  2. Leave a blank line
  3. Paste the delimited text below
  4. Run the tool to transpose it
  5. Review the columns-based output

Examples

Example

Input

|

name|age
John|30
Anna|25

Output

name|John|Anna
age|30|25

Turns normal row-based custom-delimited text into horizontal columns.

Example

Input

;

id;title
1;Book
2;Pen

Output

id;1;2
title;Book;Pen

Useful for compact custom-separated summaries.

Common errors

Using more than one character as the delimiter

Fix: Use a single-character delimiter.

Uneven row lengths create empty output cells

Fix: Check the source text because missing fields will show up as blanks.

Choosing the wrong delimiter

Fix: Make sure the input really uses the delimiter you entered.

FAQ

What does Convert Arbitrary Delimited Text Rows to Columns do?

It transposes custom-delimited text so rows become columns.

Is this different from Transpose Arbitrary Delimited Text?

It uses the same core action, but this page is framed specifically for the rows-to-columns intent.

What delimiters can I use?

Any single character such as ; | : or ,.

What if some rows are shorter?

Missing values become empty cells after conversion.

When is this tool most useful?

It is useful when normal custom-delimited rows need to become a horizontal summary.

Use cases

Related tools