View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
newexceluser
 
Posts: n/a
Default Sort a list with uneven row information

I have created a list of business card contacts with a number of columns.
Each contact also contains up to four rows of information i.e. "Address"
information (two or three rows for street address; apt/suite number; city,
state and zip), "Phone" information (with two three rows for cell phone,
telephone, fax), etc. etc.
When I attempt to "Sort" by "Ascending Order" the uneven rows of information
become separated and are placed at the bottom of the list, making the list of
very little use.
I have attempted to use a blank row between the contacts and have used no
blank row but the end result is the same.
I think there is a way to do what I want to do but I have run out of options
for trial.
Any help would be greatly appreciated.