Transpose Table
Paste a table or open a file and get it turned through a quarter of a turn: the first row becomes the first column, and so on. Short rows are filled with blanks.
Drag a file here or choose one
Worked examples
Months down the side
Item,Jan,Feb Tea,120,70 Coffee,80,60
Item,Tea,Coffee Jan,120,80 Feb,70,60
Three rows by three columns stay 3 by 3 here; the first row is now the first column.
About Transpose Table
Transposing a table swaps its two directions: the first row becomes the first column, the second row becomes the second column, and so on. A report with months across the top and products down the side becomes a report with products across the top and months down the side. It is the same table turned on its side.
It helps when another program wants the data the other way round, when a table is too wide to read and would suit being tall, or when a form or a chart expects series in rows instead of columns. Every row of the input is treated alike, including the first, so a header row becomes the first column of the result. Rows of different lengths are padded with blank cells so the result stays rectangular.
How to use Transpose Table
- Paste your table or open a file.
- Check the preview. The first row of your table is now the first column.
- Download the transposed table or copy it.
- To undo it, paste the result and transpose again.
Common uses
- Turning months across the top into months down the side
- Making a wide table taller so it is easier to read
- Preparing data for a chart that expects series in rows
- Flipping a form's answers from a row into a column
Frequently asked questions
What size is the result?
A table with 3 rows and 5 columns becomes 5 rows and 3 columns. The tool shows the size before and after.
What happens to the header row?
It is treated like any other row, so it becomes the first column of the result. The result has no header row of its own.
What if my rows have different lengths?
Short rows are padded with blank cells before the flip, so every column of the result is full length.
Does transposing twice give the original?
Yes, apart from any padding added to short rows.
Is this the same as unpivoting?
No. Transposing just swaps rows and columns. Unpivoting turns several columns into rows of name and value pairs, which is better for analysis.