Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
You're most likely going to want a Pivot Table – kobaltz Mar 14 '12 at 0:04
up vote 6 down vote accepted

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

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.