Transpose Text (Columns to Rows)
Transpose Text (Columns to Rows) in a delimited table, in your browser, with a real worked example.
What this transpose text (columns to rows) does
Swap the rows and the columns of a delimited table — the same operation as columns to rows and rows to columns. Column numbers start at one; a column can also be named by its header text.
How to use it
Transpose Text (Columns to Rows): paste the delimited text into the box above, and press Run to get the result below.
Worked example
Input:
name,role,years
Ada,engineer,7
Linus,maintainer,32
Output:
role engineer maintainer
years 7 32
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads delimited text and returns result; reloading the page discards both.
Swap the rows and the columns of a delimited table — the same operation as columns to rows and rows to columns. Column numbers start at one; a column can also be named by its header text.
Transpose Text (Columns to Rows) in a delimited table, in your browser, with a real worked example.
How to use it
Transpose Text (Columns to Rows): paste the delimited text into the box above, and press Run to get the result below.
Why it runs in your browser
The conversion happens on this page with JavaScript. Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere. The page reads delimited text and returns result; reloading the page discards both.
What to Expect
Best for
- Converting delimited text to result when the data is already on screen.
What this tool keeps
- Your input is not posted to a server, so it works offline after the page loads and nothing is retained anywhere.
Sample input
name,role,years Ada,engineer,7 Linus,maintainer,32
Sample output
role engineer maintainer years 7 32
Frequently asked questions
How do I use the transpose text (columns to rows)?
Transpose Text (Columns to Rows): paste the delimited text into the box above, and press Run to get the result below.
Is my input uploaded?
No. The text is parsed on this page with JavaScript and is never posted to a server.
Is there a size limit?
Yes: 5 MB per run. Larger input is refused with a message rather than freezing the tab.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.