Text Tools

Convert Arbitrary Delimited Text Columns to Rows Examples

Review practical Convert Arbitrary Delimited Text Columns to Rows examples so you can understand expected input, output, and common patterns faster.

Why examples matter for Convert Arbitrary Delimited Text Columns to Rows

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.

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.

Convert Arbitrary Delimited Text Columns to Rows examples

Convert pipe-separated columns to rows

Input

|

name|John|Anna
age|30|25

Output

name|age
John|30
Anna|25

Useful when fields were originally arranged horizontally.

Convert semicolon columns to rows

Input

;

id;1;2
title;Book;Pen

Output

id;title
1;Book
2;Pen

Turns horizontal custom-separated data back into normal rows.

How to use these examples

Put the delimiter on the first line
Leave a blank line
Paste the delimited text below
Run the tool to transpose it
Review the rows-based output

Compare your own input with the Convert Arbitrary Delimited Text Columns to Rows examples below before running the tool.
Keep the input format as close as possible to the example pattern when you test a new case.
If your output looks wrong, check spacing, separators, symbols, or the exact value type first.

Common mistakes in sample input

Using more than one character as the delimiter

Fix: Use a single-character delimiter.

Uneven input rows create blank values

Fix: Check the source text because shorter rows will produce empty cells.

Choosing the wrong delimiter

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

Next steps

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.

Run the main tool

Open the main Convert Arbitrary Delimited Text Columns to Rows page and test your own real input.

Open Convert Arbitrary Delimited Text Columns to Rows