| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Columns to Rows
I need to take a worksheet with columns A1, B1, C1, D1 and reformat those
into rows. I am able to create the first set using basic =worksheet2!A1, but I can't copy paste because it defaults to =worksheet2!A5 due to the intervening rows. Suggestions? |
|
#2
|
|||
|
|||
|
If I understand what you are trying to do it should work with "copy" then
"paste special" then choose "transpose". The only thing you need to remember is that your paste location cannot include a cell from the copy location. Hope this helps... Steve "RColeII" wrote: I need to take a worksheet with columns A1, B1, C1, D1 and reformat those into rows. I am able to create the first set using basic =worksheet2!A1, but I can't copy paste because it defaults to =worksheet2!A5 due to the intervening rows. Suggestions? |
| 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) | |||
Linear Mode
