Merging data

[Eric Stephens]

Hello,

I would like to be able to merge data from several cells into one, but
without much manual entry. For example, I have data that resembles this:

First Name Last Name Children's Names Sex
Joe Smith Mary F
Joe Smith Greg M
Joe Smith Joey M
Marsha Brown Cindy F
Marsha Brown April F

In this case, I would like to get the following:

First Name Last Name Boys' Names Girls' Names
Joe Smith Greg, Joey Mary
Marsha Brown Cindy, April

There are two main issues: 1) each main identifier (i.e., parent name) may
have different numbers of children (Joe has three kids, Marsha has two), and
2) I want to divide the information based on a criterion (in this example,
"Sex"). I want to aviod having to enter several concatenation formulas
manually, so does anyone have any tips on how to do this? The data is coming
from an Access query, so please let me know if I should be doing this in
Access (and, if so, how?).

Thanks,
Eric