Home » Questions » Computers [ Ask a new question ]

turn columns into rows?

turn columns into rows?

I'm working with some results from a database query in excel. Is there a way I can quickly turn two rows of data with many columns into two columns of data with many rows?

Asked by: Guest | Views: 191
Total answers/comments: 1
Guest [Entry]

Check this page. Shortly, you need to execute 'Paste Special' with 'Transpose' turned on.