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 |
All times are GMT +1. The time now is 11:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com