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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Cells every other row
Headers in row 1. Data starts in row 2. Right?
If yes, then I'd put this formula in C2: =B3 in C3: DeleteMe Select C2:C3 and drag down as far as you want. Copy C2:c### to the other columns. Convert all those formulas to values. (edit|copy, edit|paste special|values) Sort by column A Delete the rows with all those deleteme's on them (Or apply data|filter|autofilter and show just the deleteme rows. Then delete those visible rows.) Texas Nuckols wrote: 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 -- Dave Peterson |
Reply |
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 |