View Single Post
  #1   Report Post  
Magdalena
 
Posts: n/a
Default sort 2 or more rows of cells linked to one row of data

I have a spread sheet with multiple rows of data. All of these rows have
several additional cells in seperate rows. Looks a little like this:

1 Session 1 Mary Company ABC
Company XYZ
2 Session 2 John Company QRS
Company TUV
I need to sort alphabeticaly by Company while keeping the Companies linked
to the appropriate sessions. Is there a way to do this? Or if I merge the
companies into one cell can I still sort alphabetically? Please help!!