Expand/ ungroup / desummarize a flattened record?

[Nicholas_White]

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

[binu_acs · Accepted solution]

@Nicholas_White One way of doing this with the transpose and cross tab tool

[Nicholas_White]

@binu_acs ,

Thank you so much for your help.

I literally had the exact same tools, exact same order when trying to build my solution....but I didn't have them configured correctly, and my results were all over the place.

 You have saved me hours of frustration 🤑

Thanks,

Nick