ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   coverting rows to columns (https://www.excelbanter.com/excel-worksheet-functions/41384-coverting-rows-columns.html)

Rebecca

coverting rows to columns
 
How can I convert a 2 rows of titles and corresponding numbers into 2
columns?

Rebecca


Dnereb


Please rephrase
and don't be afraid to write more as neccesary.


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=397388


Blue Hornet

Select and copy the cells, then Edit / Copy (or Ctrl-C), then Edit /
Paste Special / Transpose to the new location. (I think it is possible
to overwrite part of the source location, if you want to do that.)

Chris



All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com