Skip to main content
Book Consultation →
Text tools100% FreeInstant

Rows and Columns Converter: Transpose Text and Tables

This free tool swaps rows and columns in pasted text. Transpose a table, turn a vertical list into one line, or turn a line into a vertical list, using a comma, tab, semicolon, pipe or space as the divider.

By Debmedia Technologies LLP · Kolkata, India · Updated

What Is It and When Do You Need It?

Rows and columns often need to be swapped. A list pasted down the page may be needed across, or a table may be easier to read the other way round.

Paste the data, choose the action and delimiter.

How to Use This Tool

  1. Enter or paste your input in the box or boxes above.
  2. Choose the options, if there are any.
  3. Press the button to run the tool.
  4. Read the result and use the copy button where one is shown.

How the Calculation Works

In transpose mode the text is split into lines and each line into cells. The tool builds a new table where the cell at row r and column c moves to row c and column r. In column to row mode the lines are joined by the delimiter. In row to column mode the line is split on the delimiter and each part goes on its own line.

Worked Example

The rows a,b,c and 1,2,3 transposed give a,1, b,2 and c,3.

Common Uses

  • Spreadsheet work.
  • Preparing data for forms.
  • Reshaping lists for code.
  • Reports and tables.

Tips and Common Mistakes

  • Leading and trailing spaces are kept.
  • Blank lines are ignored.
  • Use the tab delimiter to paste back into a spreadsheet.
  • Check the first result against a case you already know, so you can trust the tool for the rest.
  • Nothing you type leaves your device. The work is done by your browser, so it also works with a slow connection once the page has loaded.

Next, you may need the list to comma converter, text splitter, character counter, text repeater.

Everything runs in your browser. Nothing you type is uploaded, stored or sent to any outside service.

Frequently Asked Questions

The first row becomes the first column, the second row the second column, and so on. A table of 2 rows by 3 columns becomes 3 rows by 2 columns.
Short rows are padded with empty cells so the table stays square.
Yes. Copy the cells and choose the tab delimiter.
Not specially. Items are split on the delimiter exactly as typed. Use a CSV tool for quoted data.

Disclaimer: results are calculated in your browser from the numbers you enter. Check important results before you rely on them for money, health, safety or legal decisions.