Swapping rows and columns in Excel?

Question

Is there a quick way to turn the list in the Column to be in the Row? See example below. Note how the row and column are switched.

enter image description here

barry houdini · Accepted Answer · 2012-03-14 00:32:31Z

For a one-off change rather than TRANSPOSE worksheet function you can use the Transpose option while copying and pasting

Copy the original table then choose destination for new table and right click > choose "Paste Special" > Transpose > OK > ESC

assylias · Answer 2 · 2012-03-14 00:06:23Z

up vote 2 down vote

Yes, you can use the TRANPOSE function that does exactly that.

answered Mar 14 '12 at 0:06

assylias
28418

2 Answers