Hi Folks - not even sure how to describe this without visuals, so i'm posting a dummy sheet with an example. I'm working with school data, where a student may have failed 2 or more subjects. I want to have those subjects in the same cell, separated by a comma so that i can blend it into a mail-merge document. This way, each student will only be listed once, as opposed to what you see in the attached sheet. ID is the student, and the course listed is what they've failed.
I'm not sure Excel can do this, but i thought i'd ask. The more info i can give to our counselors, the quicker we can see more kids. Thanks for any help you can offer, even if it's a "no-way!"
Marylea
Bookmarks