Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 11th 09, 08:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 10
Default 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   Report Post  
Old November 11th 09, 10:38 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Cut Cells susu Excel Discussion (Misc queries) 0 June 5th 08 05:02 PM
Insert row above cells containing data GARY Excel Discussion (Misc queries) 4 April 28th 08 11:30 AM
How do I insert cells in a macro? ruby02monday Excel Worksheet Functions 7 July 11th 07 10:32 PM
Can't insert cells kramer31 Excel Discussion (Misc queries) 2 March 6th 07 10:59 PM
shortcut to insert cells salisshe Excel Worksheet Functions 3 May 16th 06 03:49 AM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017