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

M

Magdalena

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top