Combining multiple cells in column to relate to one cell in 1st co
 

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
its 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 doesnt get all scrambled when I sort it.

Combining multiple cells in column to relate to one cell in 1st co
 

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.

Combining multiple cells in column to relate to one cell in 1st co
 

It is difficult for me to see what you are trying to do. Is possible to
email the spreadsheet?

It is sad that we can't attach files to the posting.

Is it ok to post our email address in this forum?

"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
its 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 doesnt get all scrambled when I sort it.