Your data came through so scrambled it is difficult to know what goes with what.

Generally to keep things together make sure sure you select all the columns
before doing the sort.

Don't let Excel guess at the sort range.


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 09:55:01 -0800, Lauren
wrote:

So I am trying to figure out how to combine, merge, or expand cells so that
the following info remains together, even if I sort names alphabetically when
it’s all complete.



These are the categories….

Artist name Album Song
Bio



These are the components…..

Blue Yellow Orange
White

Green Purple
White

Red
Lavendar White

Pink Brown
White


White


White



I need all of those linked up so that when I have a different artist name
with different album, song, bio it doesn’t get all scrambled when I sort it.