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
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