Hello,
I need to expand some flattened records.
Here is some fake data, each record represents several records flattened together:
These records look like they could have been cobbled together using the GROUP BY + CONCATENATE features of the Summarize Tool.
I need to 'unsummarize' the records so that there are multiple records, one for each pairing of CHILD NAME, the START DATE of a PROGRAM, and the END DATE of a PROGRAM.
The outcome would hopefully look like this:
I have color coded the fields/values to best express what I hope for.
I've also attached the Excel file to play with.
Thanks,
Nick
