group rows between blank rows

[renee]

I have a spreadsheet with customer information listed in under the column
heading customer. I need to sort by another column, but I need to keep the
customer name, address and phone number together. I have been grouping the
customer information and sorting it by the other column. This works, but I
have thousands of rows. The rows that need to be grouped are preceeded and
followed by one blank row.

 

[Joel]

You need to put an ID number on the all the rows for the same customer so you
can keep the customer info together. I can write a macro to add an id to
each customer if I had more info on your worksheet.