Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Cells every other row
I have this on spreadsheet:
A B C D E F G H 1 # Name (blank) Add (blank) City, St (blank) ZIP << Heading 2 1 John 123 Main NYC, NY 3 Smith STE 100 00210 4 2 Mary 321 Main CHI, IL 5 Jones STE 4 60603 6 3 Joe 123 Alma DLS, TX 7 Fox Apt 7 75202 I need to move all data from every other row (odd # Rows) into the blank columns to the right and eventually up one row so that all data is on same row. I have a spread sheet that is almost 7000 rows long so Ctrl+click will take hours. There musst be a faster way. Thanks, Roxanne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Cut Cells | Excel Discussion (Misc queries) | |||
Insert row above cells containing data | Excel Discussion (Misc queries) | |||
How do I insert cells in a macro? | Excel Worksheet Functions | |||
Can't insert cells | Excel Discussion (Misc queries) | |||
shortcut to insert cells | Excel Worksheet Functions |