View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Renee Renee is offline
external usenet poster
 
Posts: 73
Default 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.