| 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
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| 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) | |||
Hybrid Mode
