Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .