There may well be an easier way to do what you need, but all I can think of
is this:

Create a blank column to the left of your list. For the sake of argument,
assume that your list is in column "B" and the blank column is column "A".
Also assume that your list starts in row 2. Put the following formula in A2
and copy it down.

=IF(B2="","",ROW())

Now merely sort columns A and B (using A as the sort key) -- for only the
rows containing your list of course. The get rid of column A.

Art

"tommy" wrote:

i have a number of records in a list in a column. I need to compress the
records so that all the records bunch up.

e.g.

rec1

rec2

rec3

becomes...

rec1
rec2
rec3

is there an automatic way to do this? i have rather a lot of records to do
it for!

rgds,

Tom