Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help copying cells into rows with spaces between
I'm trying to copy the contents from rows but need it to show
verticaly. I need to reference cells by an increment of 1 but because of the spaces between rows when I copy it increments by 4, or 5, or whatever the distance is between them. For example, I need lines 1, 5, 9... to show cells A1, A2, A3... and not A1, A5, A9... In very general terms I'm trying to get it in this format: References A1 References B1 References C1 References D1 References A2 References B2 References C2 References D2 Thanks in advance for any help or ideas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose columns to rows with spaces | Excel Discussion (Misc queries) | |||
Copying cells from varying rows | Excel Discussion (Misc queries) | |||
How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
Macro that double spaces rows for an entire worksheet? | Excel Discussion (Misc queries) | |||
How do you automatically put spaces between rows in a lengthly w. | Excel Discussion (Misc queries) |