Hello!
I am desperate for some X lookup help. I have been trying to figure this out for over a week now and either this is not feasible or I am overlooking something.
I have a registration data sheet that has child name with information for each row, so since some families are registering multiple children the parent information is duplicated. What I would like to do is extract the data to another sheet that has a summary of registrations per family listing the parent name on the column and across the row each child and the day/time they are registered. I've tried a lot different stuff but nada. Please help I've included a screen shot of the original data as well as the info I'm trying to pull.
In the family registration sheet I first sorted out the family name using the UNIQUE formula, then I tried XLOOKUP for the second one and I've tried multiple combinations and still I'm coming up with more frustration than anything else. I need to find a quicker way to sort this out because I will be adding more registrations and it would be helpful to not have to go back to this every time so that I can give the families as well as the coordinator this information.
Thanks for any help you can provide
I am desperate for some X lookup help. I have been trying to figure this out for over a week now and either this is not feasible or I am overlooking something.
I have a registration data sheet that has child name with information for each row, so since some families are registering multiple children the parent information is duplicated. What I would like to do is extract the data to another sheet that has a summary of registrations per family listing the parent name on the column and across the row each child and the day/time they are registered. I've tried a lot different stuff but nada. Please help I've included a screen shot of the original data as well as the info I'm trying to pull.
In the family registration sheet I first sorted out the family name using the UNIQUE formula, then I tried XLOOKUP for the second one and I've tried multiple combinations and still I'm coming up with more frustration than anything else. I need to find a quicker way to sort this out because I will be adding more registrations and it would be helpful to not have to go back to this every time so that I can give the families as well as the coordinator this information.
Thanks for any help you can provide