Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
2  
You're most likely going to want a Pivot Table –  kobaltz Mar 14 '12 at 0:04
add comment

2 Answers

up vote 5 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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.