Microsoft Excel: Transpose Columns and Rows

=========
QUESTION
———
You have a spreadsheet where you want the data you have entered as rows to now be in columns and the data you have entered as columns to now be in rows.

=========
ANSWER
———
Select your data, copy.
Select where you would like to paste the newly transposed data
Select the the dropdown arrow under Paste in the toolbar, and select Transpose

=========
APPLIES TO / KEYWORDS
———
Microsoft Excel

=========
REF
———
http://www.felgall.com/xl2.htm


http://www.anysitesupport.com/microsoft-excel-transpose-columns-and-rows/

By | 2011-04-06T14:54:50+00:00 April 6th, 2011|Computers, Documentation, Excel, Microsoft|0 Comments