group rows between blank rows
 

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.

group rows between blank rows
 

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.

"renee" wrote:

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.