Chris

Try selecting columns B through F and F5SpecialBlanksOK

Now EditDeleteShift cells up.

Should get what you need.


Gord Dibben Excel MVP

On Wed, 11 May 2005 12:54:01 -0700, ChrisA
wrote:

Yeah, doing it manually would take me weeks. I have a lot of data. There
must be some macro or some clever equation that could move the appropriate
data to correct location. I have about 25,000 rows of data for about 10,000
people (averaging about five rows of data per person.)

Any other ideas?

"Gordon" wrote:

ChrisA wrote:
|| Greetings to Excel Pros:
||
|| I have a worksheet that has a label in Column A. There are five more
|| columns (B, C, D, E, F) that have data in them. The label in cell
|| A1 is "John". Cell B1 is John's Hourly wage "$16.50". This is
|| where it gets tricky. Cell C2 is John's hours per week "40". Cell
|| D3 is John's 401K deductions "$250". As you can see from this
|| example, the data pertaining to John is staggered as I go down the
|| columns. I have several people in the same spreadsheet that have
|| data staggered in this fashion. Not all of them have the same
|| information with the same spacing. Mary for example only has hourly
|| wage info and hours per week info. I want to get rid of the blank
|| cells so that all of the data pertaining to an individual is on the
|| same row as the person's name. Any ideas???
||
|| I hope this was a clear explaination.
||
|| Chris

It will be a bit laborious, but if you right-click on a blank cell, and
choose "Delete" you will get several options as to whether you want to move
cells left, right, or up and down. Go through the list doing that until you
get all the data correct! You will have to do the reverse at some points and
insert cells!

--
Gordon Burgess-Parker
Interim Systems and Management Accounting
www.gbpcomputing.co.uk