Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |