Home |
Search |
Today's Posts |
#1
|
|||
|
|||
coverting rows to columns
How can I convert a 2 rows of titles and corresponding numbers into 2
columns? Rebecca |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Converting Columns to Rows | Excel Worksheet Functions | |||
How do I lookup values from rows and columns Simultaneously | Excel Worksheet Functions | |||
Can I split my worksheet and have different size columns and rows. | Excel Discussion (Misc queries) |