| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data from multiple cells into one cell. | Excel Worksheet Functions | |||
| combining multiple columns into one column - enhancements | Excel Worksheet Functions | |||
| How can I relate more than 7 cells with IF(... | Excel Worksheet Functions | |||
| Combining Text from multiple cells under multiple conditions | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
Linear Mode
