Friday, 9 September 2011

How to convert a column to a row (or vice -versa) in Excell

1- Copy the data columns or rows.
2- Right click on the first destination cell that you want to paste, and then click Paste Special.
3- Select Transpose in the Paste Special dialog box.
More details:
http://office.microsoft.com/en-us/excel-help/rotate-data-by-converting-columns-to-rows-or-vice-versa-HP005203138.aspx

No comments:

Post a Comment