View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jonathan Jonathan is offline
external usenet poster
 
Posts: 138
Default Sorting by line when multiple lines correspond to it?

Hi all,

I am working on creating a contact list and I want to be able to sort by
client name, however, there are several lines for each client name, so when I
sort by client name currently, the first line will come up fine, but then the
rest of the associated lines will all get grouped together as being "blank."
Is there any way to sort without writing the client name on each line?
Please see below. I would like all the info for client A, B, C, etc. to move
when I sort rather than just the top line.

Thanks!

Client Phone Email
A 654654 weffwefwe
654654 werw
22477 545487
323211 57778768
B 3.21132E+15 6354654
4564 5887687
C asdf asdf
sadf afds
asfd weffwefwe
asdf afds
D f asdf
E wef sdaf
sd a
d sdaf
s df
F s sdaf