sort 2 or more rows of cells linked to one row of data

[Guest]

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!!

 

[Barb Reinhardt]

I'd do something like what's described here:
http://www.contextures.com/xlCondFormat03.html#Duplicate

You'll need to have data in this form though: