View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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